Re: Oracle on EMC Clarion CX500

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 05 Apr 2005 14:10:14 -0600
Message-ID: <4252F0A6.907@centrexcc.com>

Paul,

why only after migrating to 10g? The CBO in Oracle 9i with system stats ought to do the same - derive the cost of a full scan from the MBRC system stats value rather than from the dfmrc init parameter - or do you have evidence to the contrary?

Paul Drake wrote:

>
> After you migrate to 10g (and gather system stats), you may be able to
> get away with a larger db_file_multiblock_read_count (without the CBO
> wanting to tablescan/hash_join everything) in which case a larger
> stripe size will be better.
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 05 2005 - 16:14:08 CDT