Re: Oracle on EMC Clarion CX500
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: bdbafh@xxxxxxxxx
- Date: Tue, 05 Apr 2005 14:10:14 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
