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

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
  • Date: Mon, 11 Sep 2006 15:13:36 -0500

Not me!  :)

Since this is (supposedly) an OLTP-only DB, I set it up with 8K blocks.
I'll be setting max filesizes to 28GB.

Thanks guys for hashing that out!


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nuno Souto
Sent: Saturday, September 09, 2006 1:07 PM
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: 2GB or not 2GB (datafile limit)? That is the question.

Kevin Closson wrote,on my timestamp of 10/09/2006 3:27 AM:

> 30GB is 
> almost 31.99999237060546875GB ((((2^22)-1)*8KB)/1GB)  :-)

wanna bet if someone pushes a file near that boundary
they'll spring an undocumented bug of some sort?
Me?  I'm staying near 28 or thereabouts.
And sleeping well.  ;-)

Nuno Souto
in rainy Sydney, Australia

Other related posts: