RE: SGA

From: Justin Cave <justin_at_askddbc.com>
Date: Wed, 23 Jun 2004 20:56:13 -0600
Message-Id: <20040624023655.B94A372C848@turing.freelists.org>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seema Singh
Sent: Wednesday, June 23, 2004 8:01 PM
To: oracle-l_at_freelists.org
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_at_freelists.org 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

Received on Wed Jun 23 2004 - 21:55:38 CDT