Re: About having a large SGA for a DataWarehouse

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 19 Jul 2004 09:44:35 -0400
Message-ID: <20040719134435.GA7312@medo.noip.com>

On 07/19/2004 09:39:03 AM, "Khedr, Waleed" wrote:
> Data warehouses usually require using PQO, and this uses direct reads
> that will benefit nothing of big buffer cache.

They will also not benefit much from MTS, so allocating large chunks of memory for large pool is also pointless. Hashe and sort are size will need to be exploded, typically to values like 64M/process.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
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
-----------------------------------------------------------------

Received on Mon Jul 19 2004 - 08:41:22 CDT