For a bigger list of "limitations" ... please refer to
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90190/ch
4.htm
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:ujlg06hqt0nead_at_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 - 11:10:09 CDT
