| memory in statspack [message #344059] |
Thu, 28 August 2008 12:49  |
blakshmi
Messages: 6
Registered: October 2006
Location: nj
|
Junior Member |
|
|
Not an expert in how to intrepret the statspack report results. Below is the statspack report, since sort is happening in the memory, is there any tuning opportunity, why memory is consumed the most on the server by oracle process. How could we identify what is using up all the memory in oracle processes. Besides what else should i look for culprits.
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Call Time
-------------------------------------------- ------------ ----------- ---------
log file sync 895,386 2,383 62.83
db file sequential read 50,764 407 10.74
CPU time 339 8.95
control file parallel write 27,995 227 6.00
class slave wait 37 190 5.00
-------------------------------------------------------------
Wait Events DB/Inst: CPDTMS/cpdtms Snaps: 206-229
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
