Re: Data file size limit

Sybrand Bakker wrote:
>
> "Vsevolod Afanassiev" <vafanassiev_at_aapt.com.au> wrote in message
> news:4f7d504c.0207210337.386e41f3_at_posting.google.com...
> > "Anurag Varma" <avdbi_at_hotmail.com> wrote in message
> news:<bae_8.102945$6r.3485315_at_news4.srv.hcvlny.cv.net>...
> > > 32 bit Oracle has 2G limitations .....
> > > 64 bit Oracle can handle bigger file sizes ...
> > >
> > > Anurag
> > No, 32 bit Oracle can handle files > 2 GB just fine.
> > Oracle has only one internal limit - a file cannot have more than
> 4,000,000
> > blocks (or near it). So for 8K blocks you can have 32 GB files.
> >
> > All "tuning" has to be done on OS side, nothing on Oracle side:
> > 1. Check ulimit
> > 2. Try to create a file > 2B manually (using mkfile, for example)
>
> I remember seeing docs from Oracle stating on a 32-bit o/s the limit of a
> file is 2G. I'm not sure why you contradict information in the docs.

I don't think Vsevolod is contradicting anything - he's saying that 32-bit *Oracle* doesn't have problems with datafiles larger than 2 GB, which is true. Now, a 32-bit OS may or may not have problems with such large files, but that's not Oracle's problem. It's possible to run 32-bit Oracle on a 64-bit OS and have datafiles > 2 GB. Up until last week we had a 32-bit Oracle database on Solaris 2.6 with many 32 GB datafiles and no problems (we just upgraded it to 64-bit Solaris 2.8 and 64-bit Oracle however).

Regards,
Sean Received on Sun Jul 21 2002 - 12:31:34 CDT