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

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


Other related posts: