Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: storage parameters

Re: storage parameters

From: Tim Gorman <Tim_at_SageLogix.com>
Date: Wed, 29 May 2002 07:13:32 -0800
Message-ID: <F001.0046E2D1.20020529071332@fatcity.com>


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

> 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).
Received on Wed May 29 2002 - 10:13:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US