Hi everyone,
all the developers are complaining that the db is slow while there are other databases in the same server which are heavily used too. Not sure where is the problem residing.
What kind of information should I be getting from the developers to understand the problem better? and I tried this sql and this is the result. Any clue from this one?
select (sum(gets - getmisses - fixed)) / sum(gets) "data dictionary hit ratio"
from v$rowcache;
data dictionary hit ratio
0.97865946635299
Really hope to hear some suggestions.
Thank You.
Nith