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
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.

Re: Transaction memory/space amount configuration [message #402086 is a reply to message #402021] Thu, 07 May 2009 09:19 Go to previous message
Messages: 25570
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.



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

Current Time: Thu Aug 17 16:28:01 CDT 2017

Total time taken to generate the page: 0.09281 seconds