You could probably mount a argument about more than
505 extents (for an 8k block) not being able to fit in
the segment header block - but unless you're
clobbering dba_extents and the like with queries, I
doubt you'd ever see a difference.
hth
connor
- Steve Smith <ssmith_at_ai.com> wrote: > 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
> --
>
=== message truncated ===
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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 Oct 02 2001 - 15:50:45 CDT