Re: Extents????

From: root <jkotan_at_tconl.com>
Date: Sun, 13 Jan 2002 08:47:18 -0600
Message-ID: <3C419DF6.73DB3BD6_at_tconl.com>


Yes, you will get them that way.

Jim

Rob wrote:

> 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 Sun Jan 13 2002 - 15:47:18 CET

Original text of this message