Re: 2GB or not 2GB (datafile limit)? That is the question.

  • From: Rodd Holman <Rodd.Holman@xxxxxxxxx>
  • To: Rich.Jesse@xxxxxx
  • Date: Fri, 08 Sep 2006 09:48:34 -0500

I'm running mine up to 32GB with no issues. (Well other than we keep
running out of space for 32GB files) ;)
Mainly it's a question of managing the large files at the OS level.
With most current OS's that's not an issue either.  GO BIG.

Jesse, Rich wrote:
> Many moons ago, way back in the 32-bit era when Y2K was a looming
> nightmare, I had instituted a policy that no Oracle datafile would be
> setup to grow larger than 2GB.  This was due to some known bugs with
> files larger than 2GB on many platforms/filesystems at the time.
> As I'm now looking at a vendor's ERP installation, I was about to reduce
> their max datafile size from 32GB to 2GB when I asked myself "Why?".  Is
> there any valid sane reason to do this anymore?  I do not expect the DB
> size to grow beyond a modest 100GB in the next two years.  The server is
> an IBM P5 blade running AIX5.3 and using JFS filesystems.  Other similar
> servers with other DBs (e.g. Sybase) currently handle db files in the
> 100's of GB with no problem.
> I don't see any need to limit the datafile size to 2GB anymore.  Anyone
> else?
> TIA,
> Rich
> --


Other related posts: