Home » RDBMS Server » Performance Tuning » memory in statspack (9i windows)
memory in statspack [message #344059] Thu, 28 August 2008 12:49 Go to next message
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)
Re: memory in statspack [message #344061 is a reply to message #344059] Thu, 28 August 2008 12:52 Go to previous messageGo to next message
blakshmi
Messages: 6
Registered: October 2006
Location: nj
Junior Member

more info

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 99.98
Buffer Hit %: 99.80 In-memory Sort %: 100.00
Library Hit %: 99.51 Soft Parse %: 99.20
Execute to Parse %: 54.18 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 73.10 % Non-Parse CPU: 85.87

Shared Pool Statistics Begin End
------ ------
Memory Usage %: 82.61 87.29
% SQL with executions>1: 44.24 38.24
% Memory for SQL w/exec>1: 42.58 40.43
Re: memory in statspack [message #344064 is a reply to message #344059] Thu, 28 August 2008 12:54 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

I'm confused.
I saw nothing in what you posted about sorts or memory used.

What problem are you really trying to solve?
Previous Topic: AWR Service Stats
Next Topic: Definition of wait event
Goto Forum:
  


Current Time: Sun Dec 04 02:43:56 CST 2016

Total time taken to generate the page: 0.23928 seconds