Hello:
I was calculating ratios and buffer hit cache ratio was at 65%. We were running queries on the system, more than normal. Increased the db blocks to 20000 from 10000 and increased shared pool to 256MB from 128MB. Bounced the database. Started our queries again. Now the buffer hit cache ratio went down as far as 55% and is hovering around 60%. Why am I not seeing better ratios than before though I have doubled.
Are there any other parameters, I have to work on when I change these two..
Thanks, ST2000