Re: Performance - one or multiple extents ?

Andreas Wizemann wrote:
>
> 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

Number of extents is going to make no difference...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."