Re: Extents????

Try searching on Google for "How To Stop Defragmenting And Start Living"
Basically you want a few<5 standard extent sizes. One paper I read used 160KB, 5MB, and 160MB. You are on the right track with the locally managed uniformed datafiles.
Good luck,
Rob.

george_working_at_hotmail.com (george bagley) wrote in message news:<ad097928.0111291745.31dfb3c4_at_posting.google.com>...
> 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 Wed Dec 12 2001 - 09:08:48 CET