| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: datafile size
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)
***************************************************************************=
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-lReceived on Tue Nov 02 2004 - 16:29:27 CST
 |
 |