Re: 2 GB File Limit

""Anurag Minocha"" <aminocha_at_herold.com> wrote in message news:EBBA6D3A81229C42981E3AEA79BF5A4E111242_at_jshemail.herold.com...
> Hi,
> I read somewhere that there is a 2 GB file limit in case of NT.
>

Mileage varies.... this has been discussed extensively here of late.

> What will happen if i have my datafiles and tablespaces set to autoextend
 on
> and the file size reaches 2GB.

If they just extend to 2Gb, that's fine. If they try and extend past that size (assuming, for a moment, that there really *is* a 2Gb limit), then the extension will fail. I've never experimented with multiple files of this sort of size, all with autoextend set, and hence I don't know whether Oracle will gracefully failover to extending the second (or third, or fourth etc) file when the first fails to extend. I somehow doubt it.

>Will this crash/freeze the database and what
> should be done in case this happens.
>

When you set autoextend for a datafile (which is extremely sloppy DBA'ing, IMHO), you should always specify a NEXT extension size, and also a MAXSIZE clause... you'll still get an error when the file fails to extend past its maximum possible size, but at least you are in control of when that point should be reached, rather than abandoning all responsibility, and transferring it to the O/S.

Remember that, other things being equal, a tablespace comprised of 4 500Mb datafiles will always be easier to manage, and will perform better, than a tablespace comprised of 1 2Gb file.

Regards
HJR
> Please suggest.
>
> Thanks
> Anurag
>
>
> --
> Posted from mr1.ash.ops.us.uu.net [198.5.241.86]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Mar 16 2001 - 22:04:22 CST