RE: datafile sizing question

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 26 Sep 2002 06:58:29 -0800
Message-ID: <F001.004D9E33.20020926065829@fatcity.com>

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.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----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

• John.Hallas_at_vodafone.co.uk 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: John.Hallas_at_vodafone.co.uk
  >
  > 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: 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!?
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: wisernet100_at_yahoo.com

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: 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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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: 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 Thu Sep 26 2002 - 09:58:29 CDT