| Shared Pool Statistics - StatsPack Report [message #235179] |
Fri, 04 May 2007 04:19  |
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 #235187 is a reply to message #235179] |
Fri, 04 May 2007 04:36  |
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 !!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
