Home » RDBMS Server » Performance Tuning » Transaction memory/space amount configuration (Oracle 10g)
Transaction memory/space amount configuration [message #402021] Thu, 07 May 2009 06:12 Go to next message
robmaggi
Messages: 1
Registered: May 2009
Location: Bologna (Italy)
Junior Member

Hello to all,
I'm at the first experience with Oracle tuning and configuration so I'm not sure this is the right place where to post (if it isn't then excuse me).
I'm developing an application with more than one transactional server (one it's a Oracle 10g DBMS) under 2 phase lock system.
Since in my situation there could be a large amount of statement in a single transaction I need to know what parameters I have to check and configure to avoid the DBMS to exceed memory amount and/or space limits.
I don't know where to start reading, can anybody help me? I know it's a generic question but there are so many manuals really long and so many different parameters, it takes a long time to read everything and unfortunately I don't have time.
I tried to search also in this forum but I got a lot of specific stuffs that doesn't help me to understand.
Thanks.

Rob
Re: Transaction memory/space amount configuration [message #402086 is a reply to message #402021] Thu, 07 May 2009 09:19 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> it takes a long time to read everything
But you are being paid to do so while we are not being paid

>and unfortunately I don't have time.
Neither do we.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm

http://www.orafaq.com/forum/t/84315/74940/

Enjoy!
Previous Topic: What is High water mark?
Next Topic: Query taking time
Goto Forum:
  


Current Time: Sun Jun 30 00:21:32 CDT 2024