I have been noticing that on my nt db my library cache hit is always low..69.36. I have bumped up the parms for shared_pool_size but there has been little change.
ANY IDEAS>????
-----------------------------------------------------------------
Get Hit Ratio for SQL AREA = 69.36
Get Hit Ratio for TABLE/PROCEDURE = 99.73
Get Hit Ratio for BODY = 99.49
Get Hit Ratio for TRIGGER = 99.9
Get Hit Ratio for INDEX = 0
Get Hit Ratio for CLUSTER = 99.82
Get Hit Ratio for OBJECT = 100
Get Hit Ratio for PIPE = 100
-----------------------------------------------------------------
"High Salaries = Happiness = Project Success."