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
> --
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 08 2006 - 09:48:34 CDT
