RE: SGA
- From: "Justin Cave" <justin@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 20:56:13 -0600
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
-----------------------------------------------------------------
Other related posts:
