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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nuno Souto Sent: Saturday, September 09, 2006 1:07 PM Cc: oracle-l_at_freelists.org
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_at_iinet.net.au
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l