Re: Extents????

hi there

before moving any data, take a look at dba_segments table for each of the objects to see their TOTAL BYTES & TOTAL EXTENTS

select extents , bytes from dba_segments where segment_name = 'EMPLOYEE'

this will tell you how many bytes they are using

then you can resize them by giving appropriate INITIAL EXTENT, NEXT EXTENT in the create table command.

regards

NP

george bagley <george_working_at_hotmail.com> wrote in article <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 Sun Dec 02 2001 - 02:20:15 CET