Re: 2 GB File Limit

Howard J. Rogers wrote:
>
> ""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

Although there are some bugs in Oracle 8.0.x where it (if the OS allows it), it will silently allow resize (manual or autoextend) past 2g, and of course, then get very upset about it later...

I saw it on a site - if I can get the exact versions I'll post them

Cheers
Connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"