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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
