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!

Rich


-----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.  ;-)


-- 
Cheers
Nuno Souto
in rainy Sydney, Australia
dbvision@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

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

References:
- Re: 2GB or not 2GB (datafile limit)? That is the question.
  - From: Nuno Souto

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

Other related posts: