...You cache a few more blocks than just one. The pre-fetched blocks will be cached (and, I think, pinned) as well. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 6/22 Pittsburgh, 7/20 Cleveland, 8/10 Boston - SQL Optimization 101: 5/24 San Diego, 6/14 Chicago, 6/28 Denver - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Justin Cave Sent: Wednesday, June 23, 2004 9:56 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: SGA I would hope that none of the SGA is free. If you can benefit from the memory allocated to the SGA, as opposed to allocating gobs of useless memory, what possible reason would Oracle have not to use it all? For full table scans, Oracle always puts the blocks at the least recently used side of the buffer cache, so you only cache 1 block. If Oracle has to process more rows than it can cache, it simply ages out the older blocks. Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Seema Singh Sent: Wednesday, June 23, 2004 8:01 PM To: oracle-l@xxxxxxxxxxxxx Subject: SGA Hi, How much in general % SGA should be free ? If table size is in 1GB or more and sga is 80mb how oracle will process the full scan of that particular table? thx -Seema _________________________________________________________________ Make the most of your family vacation with tips from the MSN Family Travel Guide! http://dollar.msn.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------