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><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) that with 16K blocks max file size is 64GB.</DIV>
<DIV><SPAN
class=750384314-07092000> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
Dr. Nikolay Kumanov 
MIS Manager, Zeitungsgruppe Bulgarien GmbH
 47, Tsarigradsko chaussee, Sofia 1504,
Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 <A href="mailto:nkumanov_at_zgb.bg">mailto:nkumanov_at_zgb.bg</A> 
"Show me a completely smooth operation and I'll show
you someone who's covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune" 
<BLOCKQUOTE>

<DIV class=OutlookMessageHeader dir=ltr align=left>-----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 </DIV> 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 </BLOCKQUOTE></BODY></HTML> Received on Thu Sep 07 2000 - 09:53:48 CDT