Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: datafile size

From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
To: davidsharples@xxxxxxxxx
Date: Tue, 02 Nov 2004 22:32:07 +0000

On 11/02/2004 05:02:25 PM, David Sharples wrote:
> there really is no practical limit for datafile sizes.  The argrument
> of no more than 2Gb is crass at best.

That is not quite true. So called "2GB limit" is indeed gone, but here =20
is what the fine manual says (Oracle Reference 9.2, database limits)

***************************************************************************=
***********
Database file size
=09

Maximum
=09

Operating system dependent. Limited by maximum operating system file =20
size; typically 222 or 4M b.
***************************************************************************=
**********

The  formulation "4M b", coined with the crystal clarity typical of =20
Oracle Corp. documentation, means "4 million file system blocks". =20
Typical FS block size is 4k, so 4,000,000*4096=3D16GB. In particular, =20
this limit does apply on all Linux boxes. I've seen files grow above  =20
16GB and become corrupt. So, limits are much bigger now, but you still =20
cannot go above warp 9.

--=20
Mladen Gogala
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l

References:

datafile size
From: Daniel Garant

Re: datafile size
From: David Sharples

Re: datafile size

Other related posts: