RE: SGA

...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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: