The number of extents *does* affect performance, but not for the reasons
that everyone thinks it does -and only then if you are using
dictionary-managed tablespaces. Checkout
http://www.geocities.com/howardjr2000/rtfs/extentnumbers.rtf for an
explanation as to why.
Regards
HJR
--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================
"Andreas Wizemann" <AWizemann_at_fvvag.de> wrote in message
news:gbportgaeim0ql3q98a6oururc20o460sp_at_4ax.com...
> Hi all,
> i have to tune a migration application which runs on up to 3
> WIN2000-Server Boxes in parallel ! They will read from DB-A on
> SYSTEM-A and write to DB-B on SYSTEM-B.
> Oracle is 8.1.7.1 running on AIX 433-ML08 on a H80 with 6GB RAM.
>
> The tables in DB-A which are READ-ONLY are newly created, then filled
> by SQL*Loader using a PCTFREE=0. Then the indexes are created.
>
> Tables in DB-B are empty, PCTFREE=10 and some indexes (for
> uniqueness,...) are defined.
>
> Does the number of extents (only 1 or many) influence on performance ?
> What about INITRANS and FREELIST ?
> Which init.ora parms should be set ?
>
> Thanks
>
> Andreas Wizemann
Received on Fri Oct 05 2001 - 18:33:59 CDT
