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

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Sat, 9 Sep 2006 08:16:11 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5AFA5@ex2.ms.polyserve.com>

>>>The "largest number of Oracle blocks per file" limit still
>>>applies. That's around 30GB with 8K block sizes.

                    ^^^^^^^^^^^^

might as well be precise. It is (2^21) - 1 Oracle blocks per datafile which with an 8KB block is 8K short of 16GB.

A 10g BIGFILE tablespace supports 2^32 blocks which is 32TB for a single file tablespace...they are limited to 1 file per tablespace.

The whole topic is noise really, modern Oses handle axtremely large numbers of file descriptors without issue... so choose what makes sense... our QA tests here include OLTP stress tests with databases that consist of 16383 datafiles "evenly" distributed throughout 512 filesystems...just for bounds testing...

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Sep 09 2006 - 10:16:11 CDT