Rachel - In the whitepaper "How to Stop Defragmenting and Start Living", they make a big deal under LMT about selecting specific extent sizes, and those optimum sizes are different for Oracle 8i and Oracle 8. For Oracle 8i the sizes are 128k, 4m, 128m. I couldn't follow the complete logic of why they selected those sizes, but I felt that I should follow the prescription rather than get creative in my ignorance. Perhaps someone else has an explanation. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message----- Sent: Thursday, September 26, 2002 6:03 AM To: Multiple recipients of list ORACLE-L 10001Mb? the uniform extent sizes map to what I'll be using as well. good to know I'm not way off track --- [EMAIL PROTECTED] wrote: > We tend to use multiples of 1Gb and add 1 Mb to the file so that we > get > 2001, 10001 Mb etc > Solaris 2.8 > LMT uniform extents range from 64K to 20Mb > > John > > -----Original Message----- > Sent: 25 September 2002 19:44 > To: Multiple recipients of list ORACLE-L > > > > We created two datafiles of 16GB+64K all LMT autoallocate ... never > gave a > problem. A basic testing concluded that fixed size allocation of 128M > caused > unnecessary delays whereas autoallocate was much faster. I don't know > the > full details yet, but I'll know soon. > > Of course this is undergoing lot of testing (the whole application, > no > problems with datafiles yet), but we will probably settle for about > 4GB+64K. > This is AIX5L 64 bit running Oracle 9iR2. > > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of > ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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!? New DSL Internet Access from SBC & Yahoo! http://sbc.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 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
