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 <[EMAIL PROTECTED]> 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" > <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).