Home » RDBMS Server » Performance Tuning » Shared Pool Statistics - StatsPack Report
Shared Pool Statistics - StatsPack Report [message #235179] Fri, 04 May 2007 04:19 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

Can anybody help to read following section of StatsPack Report.
Version - 9iR2

Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   36.14   36.46
    % SQL with executions>1:   33.65   33.72
  % Memory for SQL w/exec>1:   35.74   36.14



Regards
Brayan.
Re: Shared Pool Statistics - StatsPack Report [message #235184 is a reply to message #235179] Fri, 04 May 2007 04:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you already know about Statspack report?
Did you read spdoc.txt in your $ORACLE_HOME/rdbms/admin directory, it is the first step.
Have a look at documents at: Performances White Papers.

Regards
Michel
Re: Shared Pool Statistics - StatsPack Report [message #235187 is a reply to message #235179] Fri, 04 May 2007 04:36 Go to previous messageGo to next message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
Memory Usage:Percenatge of shared pool in use.
As a rule of thumb expected to be between 70-85% for effective ststems.
If the value is low then the memory is wasted.If its high the shared pool is used heavily which means that you are aging certain components out from there.


SQL with executions > 1 How many sql statements were found in the shared pool executed more than once.
If the system runs the same working set of sql continously then this would be 100% .
From the current data we can infer that the window period when the stats were collected 34% of the sqls were executed more than once.
The remaining statements were there and the system did not execute it.

Memory for SQL w/exec>1 Measure of memory consumed by the SQL's used frequently compared to sql's not used frequently.
Not sure about the usefulness of this though !!
Re: Shared Pool Statistics - StatsPack Report [message #235241 is a reply to message #235179] Fri, 04 May 2007 08:01 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

Thanks a lot.
Previous Topic: Movting Index partitions to differenet tablespaces.
Next Topic: Gather Statistics - SYS
Goto Forum:
  


Current Time: Fri Dec 09 17:32:30 CST 2016

Total time taken to generate the page: 0.15567 seconds