Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> KEEP Pool and full-table scans?
I understand that Oracle will read full-table scan data blocks directly into the PGA, byassing the data buffer.
If this is true, is there a way to cache ( using the KEEP pool ), small tables (less than 20 data blocks) that experience frequent fulltable scans?
If I KEEP the small table, will Oracle still read it from the data file into the PGA?
-- Posted via http://dbforums.comReceived on Mon Aug 25 2003 - 20:13:21 CDT