Re: storage parameters

LOL! Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 28, 2002 2:58 PM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.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).