Re: file size 2GB limit

On WinNT 4.0, when having (data)files bigger then 2GB, Windows can't do a asynchronous write to that file.
This means that when windows has to write to that file, it waits until it is finished before doing the next action.. So it's better to keep all your datafiles =< 2GB. When you need more, just add another datafile with maxsize=2000M.

Greetings,
Victor.

yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0108012031.98dd75_at_posting.google.com>...
> It's Oracle's restriction that makes some Oracle bahavior "unpredictable".
>
> Why do you need a datafile bigger than 2G?
>
> Yong Huang
> yong321_at_yahoo.com
>
> "Zhenming Wang" <zmwang_at_sympatico.ca> wrote in message news:<xIW97.20729$D55.1549671_at_news20.bellglobal.com>...
> > I wonder whether NT4.0 NTFS file system supports large file size (>2GB)
> > when Oracle server installed on it. Is it NT 32-bit restriction or Oracle's
> > restriction? Which Oracle version is a 64-bit?
> >
> > Zhenming
Received on Thu Aug 02 2001 - 05:50:49 CDT