True - but we're all using LMT's now anyway aren't we ? :-)
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > 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). ===== 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).