-
Hi,
I have a table that has about 200,000 rows. Most of the queries do full table scan since they retreive large portion of this table. On every table scan I get very low (sometimes even 0%) buffer cache hitratio. I set the table with the CACHE parameter to cache the retrieve rows, but it still has low cache hit ratio.
How do i increase teh hit ratio? shoul I increase the buffer cache (for now it is 78 MB) and my total RAM is392 MB..
What should I do?
Thanx!
-
I think the 'cache'd table is consuming lots of space in you buffer cache, leaving to little space for other data, resulting in a low hit ratio.
Hope this helps
Gert
-
If you are using Oracle8 or 8i, you might consider splitting your buffer cache into KEEP, RECYCLE, and DEFAULT pools. You can then specify your table should be loaded in the KEEP pool and (assuming everything is sized properly) it won't be aged out as quickly.
