Home » RDBMS Server » Performance Tuning » Monitoring memory used by oracle process  () 1 Vote
Monitoring memory used by oracle process [message #166970] Mon, 10 April 2006 10:48 Go to next message
Messages: 24
Registered: October 2004
Junior Member
I'm monitoring the memory used by oracle process.
I have a process which make a lot of connections to oracle in order to execute sql sentences.
I think that my oracle process are spending much memory. Using unix comands to watch it, i can see:

user 2064598 15,3 1,0 55056 25684 oracleTW9
user 2105482 0,0 1,0 54392 25752 oracleTW9
user 1876164 0,0 1,0 54364 25720 oracleTW9
user 1867888 0,0 1,0 54364 25596 oracleTW9
user 1884370 0,0 1,0 54364 25712 oracleTW9
user 1859738 0,0 1,0 54364 25720 oracleTW9

I'm not sure bit i thinks that data about memory (%MEM, SZ , RSS) are high because the oracle process are sql sentences with low volume of data (not heavy sql)

Is there any way to reduce this memory used???, can I modify my connection to oracle in order to change a memory parameter??

Any advice will be greatly apreciatted
Re: Monitoring memory used by oracle process [message #167091 is a reply to message #166970] Tue, 11 April 2006 05:13 Go to previous message
Messages: 59
Registered: March 2006
Location: hyderabad,india
it depends on the SGA components,PGA and processes you should evaluate your requirement. look at the SQL statements what they are actully doing (any sort operations etc.,). it all depends on the application logic how you are managing connections to oracle. imo there is little you can manage at server side. check the idle connections also, if necessary create resource profile

Previous Topic: Performance for Full table scan ( Huge data )
Next Topic: Oracle 8 rebuild index
Goto Forum:

Current Time: Wed May 22 19:12:48 CDT 2024