Parse to execute ratio in oracle
Posted on 2006-07-05
I have oracle9i enterprise edition release 18.104.22.168.0 - 64-bit .
In toad Server Statistics, i have seen the following analysis,
Library Cache Get Hit Ratio - 89,2053 -- Dynamic or Unsharable SQL ?
Parse to Execute Ration - 84,1742 -- High Parse to Execute ration
DBWR Average Scan Depth - 765,7342 -- Number of DB_FILES too high
Last two are red, i think database require some tuning,
Please, some body tell me what i should do to resolve it,