| Monitoring memory used by oracle process [message #166970] |
Mon, 10 April 2006 10:48  |
Nau
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 PID %CPU %MEM SZ RSS COMM
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  |
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
|
Member |
|
|
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
Thanks
Madhu
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
