Re: Data file size limit

From: Ban Spam <ban-spam_at_operamail.com>
Date: Mon, 22 Jul 2002 00:31:11 GMT
Message-ID: <Xns9252B237DC8CCSunnySD@68.1.17.6>

Sean M <smckeownNO_at_BACKSIESadelphia.net> wrote in news:3D3AEFF6.DBDBC7E1_at_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
>

IIRC, with "32-bit" Oracle (minor?) things like export/import did NOT work with files > 2GB; regardless of whether or not the OS supported files > 2GB.

YMMV Received on Sun Jul 21 2002 - 19:31:11 CDT