Fw: storage parameters

Whoops! Sorry about that one, listers! Made the usual mistake with "reply" button...

That was intended for Jay Earle, who is east of Maine and west of Nova Scotia and 'way north of the Mason-Dixon line...

• Original Message ----- To: <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 29, 2002 8:08 AM

> We're one game away from beating the Red Wings; how are the Maple Leafs
> doing? I haven't been paying attention...
>
> ...the Red Wings are the better coached and are just the better team, but
> the Avs are showing enough grit to take the lead in the series. Gotta
love
> it...
>
> ----- Original Message -----
> From: "Jay Earle (DBA)" <Jay_Earle_at_smartforce.com>
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, May 28, 2002 1:03 PM
> Subject: RE: storage parameters
>
>
> > Hi Fazia,
> >
> > I would recommend the following white paper, it advocates using the SAFE
> > methodology.
> >
> > HOW TO STOP DEFRAGMENTIING AND START LIVING
> > Bhaskar Himatsingka, Oracle Corporation
> > & Juan Loaiza, Oracle Corporation
> >
> >
> >
> > You can find the paper on Cary Millsap's site. www.hotsos.com
> >
> >
> >
> > Sincerely,
> >
> > Jay
> >
> >
> > Jay Earle, BSc(CS) (jay_earle_at_smartforce.com)
> > DBA, Operations Group
> > SmartForce, Learning Solutions for the Human Enterprise
> > -----Original Message-----
> > Sent: Tuesday, May 28, 2002 3:30 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > > 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: Jay Earle (DBA)
> > INET: Jay_Earle_at_smartforce.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: Tim Gorman
  INET: Tim_at_SageLogix.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).