-
I have generated the report spreport and here a small portion of the result that i got.
It gives me my Top 5 Wait Events: are they tunable, are those waits are normal?
My Execute to Parse hit ratio is at 4.42 %
What should i do?
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 91.43 In-memory Sort %: 99.54
Library Hit %: 97.27 Soft Parse %: 95.83
Execute to Parse %: 4.42 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: % Non-Parse CPU:
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 95.08 16.27
% SQL with executions>1: 91.41 69.20
% Memory for SQL w/exec>1: 86.61 54.55
Top 5 Wait Events
~~~~~~~~~~~~~~~~~
Wait % Total Event Waits Time (cs) Wt Time
------------- ------------ ------------ -------
db file sequential read 115,950 0 .00
direct path read 88,154 0 .00
direct path write 83,153 0 .00
db file scattered read 69,624 0 .00
SQL*Net more data to client 62,901 0 .00
-------------------------------------
[Edited by steeve123 on 05-03-2001 at 11:02 AM]
-
-
i did, and it's not helping me
