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.

Oracle LazyDBA home page