I copied this information from STATSPACK report.

Regards,
Sreedhar

-----Original Message-----
From: Mudhalvan Moovarkku [mailto:[Email address protected]
Sent: Tuesday, November 29, 2005 12:55 PM
To: Sreedhar_Bhaskararaju
Subject: RE: Shared Pool Statistics # Discuss

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


Hi Bhaskar,

Can you send me the SQL using to Get these Values

Regards
Mudhalvan M.M

-----Original Message-----
From: Sreedhar_Bhaskararaju
[Email address protected]
Sent: Tuesday, November 29, 2005 3:54 PM
To: LazyDBA Discussion
Subject: Shared Pool Statistics # Discuss

Hi All,



Can some body analyze that what are the bench marks for the following 3
parameters?



Shared Pool Statistics Begin End CRITICAL

------ ------

Memory Usage %: 46.85 48.73 ?

% SQL with executions>1: 74.61 77.26 ?

% Memory for SQL w/exec>1: 66.79 75.75 ?



At what percentages it can be treated as critical?



Thanks in advance.



Regs,

Sree



DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html






DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.


Oracle LazyDBA home page