Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Data file size limit

Re: Data file size limit

From: Sean M <smckeownNO_at_BACKSIESadelphia.net>
Date: Sun, 21 Jul 2002 11:31:34 -0600
Message-ID: <3D3AEFF6.DBDBC7E1@BACKSIESadelphia.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US