Re: Oracle Datafile size in Windows NTFS

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 3 Dec 2002 22:11:46 -0000
Message-ID: <3ded2d8d_2@mk-nntp-1.news.uk.worldonline.com>

"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3dec8a0d$0$31536$afc38c87_at_news.optusnet.com.au...
> Tue, 3 Dec 2002 10:08:20 -0000, Niall Litchfield said (and I quote):
>
> > autoextend) to a size I was comfortable with. I picked 4gb - result one
dead
> > financial system :(. Similar bugs with 2gb and 4gb datafiles have
existed on
> > various operating systems and various versions of Oracle.
>
> Rule #1 of defensive IT: never size anything at a power of 2 boundary.
> Particularly if that boundary is near a hardware limitation.
>

Nuno,

Couldn't agree more. I think we've been here before. I too have an aversion to 'boundaries'.
For this reason I prefer to limit datafile size to 2000m (not 2G!), whatever the OS.

Conservative? Yes.
Paranoid? Maybe.
Still in a job? Best chance.

Regards,
Paul

P.S. I know I'm irrational, but I don't like autoextend either. So there! Received on Tue Dec 03 2002 - 16:11:46 CST