Re: Data file size limit

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 21 Jul 2002 15:09:15 +0200
Message-ID: <ujlg06hqt0nead@corp.supernews.com>

"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.

Regards Received on Sun Jul 21 2002 - 08:09:15 CDT