Tuning buffer hit ratio should really impress your PHB. Are you "tuning an instance", or you have a problem with an application that you really need to fix. I don't misunderestimate the compulsive tuning disorder, but that should be kept private. After Cary's book, this issue no longer resignates with people. -- Mladen Gogala A & E TV Network Ext. 1216 > -----Original Message----- > From: Seema Singh [mailto:oracledbam@xxxxxxxxxxx] > Sent: Friday, October 01, 2004 11:05 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: STATSPACK > execute to parse % ratio is too low.How to fix that one? > thanks -- //www.freelists.org/webpage/oracle-l