Hello :

I use TOAD for checking server statistics apart from running physical queries to check all the ratios.. It has resulted very favorably many times. But for few environments, constantly I see some parameters which I cannot get rid of..

HIGH PARSE:EXECUTE RATIO 65%

HIGH PARSE CPU OVERHEAD @24

Shared Pool area too small (I should increase variable size)
Library Cache Pin Hit ratio 83%(for above)
Library Cache Get Hit Ratio 83% (dynamic or shareable sql?)

DBWR average scan depth 276 (Number of dbfiles too high??) and I have only 7 tablespaces and 21 datafiles at 20GB size of database.

The above are across multiple instances. (5 having an SGA of 1G and about 200GB totally)

What is the general recommendation for looking into the above?

Thanks, ST2000