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).
Received on Tue May 28 2002 - 14:03:30 CDT