Re: Extents size.

Yea - I keep hearing and seeing tests that show that the number of extents had no bearing on performance (up to a point). It just 'bothers' me to see a 500 or 1200 or 2000 extents on a table.. <grin>

Here is a question - is there any situation that having only 1 big extent would reduce performance?

Steve

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 02, 2001 10:30 AM

> well, only when you are deleting massive amounts of data or truncating
> with drop storage.. then there is an impact because of the hits on the
> dictionary tables.
>
> but basically yes... I've been told by various Oracle employees that up
> to 4096 extents cause no problem whatsoever.
>
>
> --- Christopher Spence <cspence_at_FuelSpot.com> wrote:
> > That is completely a myth. There is no notable performance different
> > with a
> > table with 10,000 extents and one with 1.
> >
> > The only problem is when it comes to the bitmaps when dealing with
> > LMT and
> > cluster when dealing with dictionary managed. When you query the
> > extent
> > views, or do space management type processes.
> >
> > "Do not criticize someone until you walked a mile in their shoes,
> > that way
> > when you criticize them, you are a mile a way and have their shoes."
> >
> > Christopher R. Spence
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax: (707) 885-2275
> >
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >
> >
> >
> > -----Original Message-----
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > May be it is good practice to keep number of extents to be less than
> > 50, no
> > matter what the size of extent.
> >
> >
> >
> > -----Original Message-----
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello,
> >
> > I'll do an reorganization of a database (about 140 gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I have also many
> > small
> > indexes (less than 16K).
> >
> > Regards,
> >
> > Thanh-truc Nguyen
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Thanh-truc Nguyen
> > INET: truc_at_nguyen.as
> >
> > 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: Wong, Bing
> > INET: bing.wong_at_IngramMicro.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: Christopher Spence
> > INET: cspence_at_FuelSpot.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!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.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: Steve Smith
  INET: ssmith_at_ai.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).