Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Max datafilesze in ORACLE8i

RE: Max datafilesze in ORACLE8i

From: Nikolay Kumanov <nkumanov_at_zgb.bg>
Date: Thu, 7 Sep 2000 17:53:48 +0300
Message-Id: <10612.116413@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C018DB.6DC67140
Content-Type: text/plain;

        charset="iso-8859-1"

Usually the max file size for any version/OS combination is specified in the Administration guide for the platform. For example, my guide for 8.1.6/WinNT says (appendix B) that with 16K blocks max file size is 64GB.  

The other side of the story is that many OSes and many Oracle releases are supposed to have various documented and undocumented problems with sizes>2GB. That's why most of the experts I have talked with prefer to play safe and not to make any file larger than 2GB. The same apllies to the autoextend feature - the paranoic DBAs don't use it.  

Dr. Nikolay Kumanov

MIS Manager, Zeitungsgruppe Bulgarien GmbH 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 mailto:nkumanov_at_zgb.bg <mailto:nkumanov_at_zgb.bg>

"Show me a completely smooth operation and I'll show you someone who's covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune"

-----Original Message-----
From: Uma Sankara_Sivadanam [mailto:UmaSankara_Sivadanam_at_satyam.com] Sent: Thursday, September 07, 2000 3:01 PM To: Multiple recipients of list ORACLE-L Subject: Max datafilesze in ORACLE8i

Hi List,
I am not sure whether this question is put or not in the list. Is there any limit oracle imposes on the size of a datafile.Somebody said it is 2GB.
Can any one of you tell me the max datafile size possible and also the oracle recommended size.It is for Oracle 8.1.5.

Thanx
Uma Shankar

------_=_NextPart_001_01C018DB.6DC67140
Content-Type: text/html;

        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Max datafilesze in ORACLE8i</TITLE>

<META content="MSHTML 5.50.4207.2601" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=750384314-07092000>Usually the max file size for any version/OS combination is specified in the Administration guide for the platform. For example, my guide for 8.1.6/WinNT says (appendix B)&nbsp;that with 16K blocks max file size is 64GB.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=750384314-07092000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=750384314-07092000>The
other side of the story is that many OSes and many Oracle releases are supposed to have various documented and undocumented problems with sizes&gt;2GB. That's why most of the experts I have talked with prefer to play safe and not to make any file larger than 2GB. The same apllies to the autoextend feature - the paranoic DBAs don't use it.</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<P><FONT face=Arial size=2>Dr. Nikolay Kumanov</FONT> </P>
<P><FONT face=Arial size=2>MIS Manager, Zeitungsgruppe Bulgarien GmbH</FONT>
<BR><FONT face=Arial size=2>47, Tsarigradsko chaussee, Sofia 1504,
Bulgaria</FONT> <BR><FONT face=Arial size=2>phone: +(359-2)4339-643, fax: +(359-2)946-1286</FONT> <BR><U><FONT face=Arial color=#0000ff size=2><A href="mailto:nkumanov_at_zgb.bg">mailto:nkumanov_at_zgb.bg</A></FONT></U> </P>
<P><FONT face=Arial size=2>"Show me a completely smooth operation and I'll show
you someone who's</FONT> <BR><FONT face=Arial size=2>covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune"</FONT> </P>
<BLOCKQUOTE>

  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma   size=2>-----Original Message-----<BR><B>From:</B> Uma Sankara_Sivadanam   [mailto:UmaSankara_Sivadanam_at_satyam.com]<BR><B>Sent:</B> Thursday, September   07, 2000 3:01 PM<BR><B>To:</B> Multiple recipients of list   ORACLE-L<BR><B>Subject:</B> Max datafilesze in ORACLE8i<BR><BR></FONT></DIV>   <P><FONT face=Arial color=#0000ff size=2>Hi List,</FONT> <BR><FONT face=Arial   color=#0000ff size=2>I am not sure whether this question is put or not in the   list.</FONT> <BR><FONT face=Arial color=#0000ff size=2>Is there any limit   oracle imposes on the size of a datafile.Somebody said it is 2GB.</FONT>   <BR><FONT face=Arial color=#0000ff size=2>Can any one of you tell me the max   datafile size possible and also the oracle recommended size.It is for Oracle   8.1.5.</FONT> </P>
  <P><FONT face=Arial color=#0000ff size=2>Thanx</FONT> <BR><FONT face=Arial   color=#0000ff size=2>Uma Shankar</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Thu Sep 07 2000 - 09:53:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US