RE: datafile sizing question

From: <John.Hallas_at_vodafone.co.uk>
Date: Thu, 26 Sep 2002 04:28:28 -0800
Message-ID: <F001.004D9C2E.20020926042828@fatcity.com>

Yes, 10Gb datafiles.
I think we have a 35Gb datafile somewhere but I have not looked at that database myself

John

-----Original Message-----
Sent: 26 September 2002 12:03
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: 
  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).

Received on Thu Sep 26 2002 - 07:28:28 CDT