Performance - one or multiple extents ?

From: Andreas Wizemann <AWizemann_at_fvvag.de>
Date: Thu, 04 Oct 2001 20:26:21 +0200
Message-ID: <gbportgaeim0ql3q98a6oururc20o460sp@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 Thu Oct 04 2001 - 13:26:21 CDT