THIS IS THE RESULT WE RECENTLY GOT:
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 82.78 In-memory Sort %: 99.95
Library Hit %: 94.15 Soft Parse %: 90.41
Execute to Parse %: -22.10 Latch Hit %: 99.96
Parse CPU to Parse Elapsd %: 85.12 % Non-Parse CPU: 99.96
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 88.41 82.33
% SQL with executions>1: 44.08 75.78
% Memory for SQL w/exec>1: 40.65 22.46
Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
db file scattered read 864,289 ############ 50.00
db file sequential read 56,338 ############ 50.00
direct path write 11,160 4,888 .00
SQL*Net break/reset to client 984 3,544 .00
log file sync 16,792 2,340 .00
thing looks better;however, I think there is still FTS going on in the database. The problem is our company is the one who wrote this code. Beside the hint, is there any other way to be sure Oracle used Index, as I mentioned before, all of the indexes are there.
JEff???? Amar ?????? any advises????
This database is 8172 and I know 8172 is not good version which had a lot of bugs but I am not sure they are related with this issue.
