Sreedhar,

That looks like part of the output from a Statspack Report. To learn how to
set up and run statspack, go here: http://tahiti.oracle.com

Regards,

Johan

-----Original Message-----
From: Sreedhar_Bhaskararaju
[mailto:oracledba-ezmlmshield-x6792016.[Email address protected]
Sent: 29 September 2005 03:06
To: LazyDBA Discussion
Subject: Instance Efficiency Percentages


Hi All,



Can you please post the query to find out following Instance Efficiency
Percentages?



Instance Efficiency Percentages (Target 100%)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

Buffer Hit %: 98.42 In-memory Sort %: 100.00

Library Hit %: 93.18 Soft Parse %: 92.75

Execute to Parse %: 44.03 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 58.54 % Non-Parse CPU: 76.00



Regards,

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

Oracle LazyDBA home page