RE: storage parameters

I have to respectfully disagree. Creating everything in one huge extent and so called "defragmentation" are extremely important and save thousands of jobs at Seagate, Conner, Quantum, Maxtor, EMC and Hitachi. I cannot overemphasize an importance of such policy for the healthy growth of the storage industry.

> -----Original Message-----
> From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
> Sent: Tuesday, May 28, 2002 2:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: storage parameters
>
>
> > An example: Think of load a lot of data into a table, and then load
> > on a very limited basis. This tells me to create a large first
> >extent that everything can fit into.
>
> why? there is no benefit to that
>
>
> --- basher 59 <kb7yss_at_hotmail.com> wrote:
> > No. I can think of several reason when you would not wan them the
> > save.
> > An example: Think of load a lot of data into a table, and then load
> > on a
> > very limited basis. This tells me to create a large first extent
> > that
> > everything can fit into. Example: Say 100M and then you may want
> > to make
> > next extents 5M. Based on the fact that you won't be reaching the
> > second
> > extent for a while.
> >
> > Also the temp tablespace is used to sort. I had an instance where
> > the
> > sorts were taking a long time. I looked at the temp tablespace and
> > found
> > out that my current sort was using 300 extents of a very
> small size.
> > I
> > increase my extent size to a large number, where the sort
> only took 4
> >
> > extents and it really speeded up my sort. To optimize everything I
> > look at
> > the majority of my sorts and tried to make my first entent
> give me 90
> > % of
> > these sorts. Which was somewhat small, and then I made my next
> > extents
> > large enough so my largest sort did not use more than about
> (5 to 10)
> >
> > extents.
> >
> > MN
> >
> >
> > >From: "Malik, Fawzia" <Fawzia.Malik_at_bskyb.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: storage parameters
> > >Date: Tue, 28 May 2002 08:18:37 -0800
> > >
> > >
> > >Hi,
> > >
> > >Does Oracle reccommend having the initial and next extents set at
> > the same
> > >values???
> > >I am tidying up a current schema and the values are non uniform all
> > the way
> > >through- any comments would be very much appreciated
> > >
> > >Rgds
> > >
> > >Fawzia
> > >
> > >
> >
> >*************************************************************
> *********
> > >Information in this email is confidential and may be privileged.
> > >It is intended for the addressee only. If you have received it in
> > error,
> > >please notify the sender immediately and delete it from
> your system.
> > >You should not otherwise copy it, retransmit it or use or disclose
> > its
> > >contents to anyone.
> > >Thank you for your co-operation.
> >
> >*************************************************************
> *********
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Malik, Fawzia
> > > INET: Fawzia.Malik_at_bskyb.com
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing
> > Lists
> >
> >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like
> subscribing).
> >
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at
> > http://explorer.msn.com/intl.asp.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: basher 59
> > INET: kb7yss_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> > Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).