Extents????

Hi

I have a database with a user tablespace of 25GB.

10 tables are between 1 million and 4 million rows, the rest are anything from 0 to 500000 rows.

There are 181 tables in this tablespace and 450 indexes. (The indexes are built as part of the app and I am loath to move them)

I am re-creating this database onto a less powerful machine, so I want to get sizing perfect, as this machine will only have ten disks and the app is VERY i/o intensive..

I planned to use the following comand;

CREATE TABLESPACE "SUNUSERS"
    LOGGING
    DATAFILE '/u02/oradata/SUN/SUNUSERS_00.dbf' SIZE 1500M REUSE,

'/u03/oradata/SUN/SUNUSERS_01.dbf' SIZE 1500M
REUSE,
'/u04/oradata/SUN/SUNUSERS_02.dbf' SIZE 1500M
REUSE,
'/u05/oradata/SUN/SUNUSERS_03.dbf' SIZE 1500M
REUSE,
'/u02/oradata/SUN/SUNUSERS_04.dbf' SIZE 1500M
REUSE,
'/u03/oradata/SUN/SUNUSERS_05.dbf' SIZE 1500M
REUSE,
'/u04/oradata/SUN/SUNUSERS_06.dbf' SIZE 1500M
REUSE,
'/u05/oradata/SUN/SUNUSERS_07.dbf' SIZE 1500M
REUSE,
'/u02/oradata/SUN/SUNUSERS_08.dbf' SIZE 1500M
REUSE,
'/u03/oradata/SUN/SUNUSERS_09.dbf' SIZE 1500M
REUSE,
'/u04/oradata/SUN/SUNUSERS_10.dbf' SIZE 1500M
REUSE,
'/u05/oradata/SUN/SUNUSERS_11.dbf' SIZE 1500M
REUSE,
'/u02/oradata/SUN/SUNUSERS_12.dbf' SIZE 1500M
REUSE,
'/u03/oradata/SUN/SUNUSERS_13.dbf' SIZE 1500M
REUSE,
'/u04/oradata/SUN/SUNUSERS_14.dbf' SIZE 1500M
REUSE,
'/u05/oradata/SUN/SUNUSERS_15.dbf' SIZE 1500M
REUSE
    EXTENT MANAGEMENT LOCAL
    UNIFORM SIZE 10240K Will this mean that when I import the data, I will get (25gb/extent size of 10M) extents???

What should I set the extent size to?

recommendations would be appreciated.

Thanks

George Received on Fri Nov 30 2001 - 02:45:02 CET