From: rbenjamin@smithemery.com (Rob)
Newsgroups: comp.databases.oracle
Subject: Re: Extents????
Date: 12 Dec 2001 00:08:48 -0800
Organization: http://groups.google.com/
Lines: 72
Message-ID: <61c9d532.0112120008.41238e98@posting.google.com>
References: <ad097928.0111291745.31dfb3c4@posting.google.com>
NNTP-Posting-Host: 66.81.2.138
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1008144528 18888 127.0.0.1 (12 Dec 2001 08:08:48 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 12 Dec 2001 08:08:48 GMT


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@hotmail.com (george bagley) wrote in message news:<ad097928.0111291745.31dfb3c4@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