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.




Reply With Quote