RE: datafile sizing question

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Thu, 26 Sep 2002 08:48:29 -0800
Message-ID: <F001.004DA255.20020926084829@fatcity.com>

Goddess:

   The conclusions are correct. The OS must be configured to properly handle the 64-bit architecture, thus, large files. The 32-bit limitation on 2GB files is still imposed unless this occurs. Although Oracle can accommodate > 2GB files, you must have the OS handle the "outside Oracle" work.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation

Direct:	(248) 865-4350
Mobile:	(248) 408-2918
Email:	Stephen.Karniotis_at_Compuware.com
Web:	www.compuware.com

 -----Original Message-----
Sent:	Wednesday, September 25, 2002 4:39 PM
To:	Multiple recipients of list ORACLE-L
Subject:	RE: datafile sizing question

I think it's automatic on Solaris 2.8 but I don't know for sure so I'd rather not rely on it.

I'm going with 2001M and creating about a year's worth of tablespaces/partitions..... 101 datafiles and tablespaces. Just to START. my aching typing fingers!

• Paul Baumgartel <treegarden_at_yahoo.com> wrote:
  > I believe that the OS filesystem has to be configured for large file
  > support (on HP-UX, it's a kernel parameter) to allow files > 2 GB.
  >
  > I usually just add 1 MB to the file size to allow for the header.
  > Personally, I'd play it safe and go with however many 2001 MB files
  > you
  > need to accommodate your objects.
  >
  >
  > --- Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
  > > I'm betting that it's not 64-bit Oracle. See, I am the development
  > > DBA.
  > > As an employee, I get to create the scripts, but I don't get to run
  > > them or even get access as "oracle" to the servers.
  > >
  > > In other words, all the grunt work, all the responsibility for
  > > problems
  > > (production is managed by a hosting company) but none of the power
  > to
  > > make sure it's right.
  > >
  > > I love my job. Why?
  > >
  > > Rachel
  > >
  >
  >
  >
  > __________________________________________________
  > 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: Paul Baumgartel
  > INET: treegarden_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).
  

  ---

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



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: Stephen_Karniotis_at_compuware.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 - 11:48:29 CDT