Re: Max Size Datafile in 10g

Howard J. Rogers wrote:

> I haven't bothered to check just yet... are we still allowed 64K files per
> bigfile tablespace? Hence the limit would be 64,000-ish times 8 Exabytes??
>

The direct link to the theoretical 'physical' limits of 10g is

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/limits002.htm

Yes, they show a limit of 64K files/tablespace.

They also show typical file size limited to 2^22 blocks (but OS dependant), traditional tablespaces limited to 2^22 blocks, bigfile tabelspaces limited to 2^32 blocks, and blocks limited to 2^15 = 32KB.

> I was pretty certain 8 Exabytes was the total per-tablespace limit, but I
> was just wondering...
>
> If I thought for a minute that anybody on the face of the planet, apart
> from the CIA, actually needed 8 Exabytes, I'd care enough to look it up...
>

However, for proper national security, I'm sure you'll agree that a year's worth of full motion video surveillance (2GB/hour [2^32] * 8760 hours/year [2^13]) for each of the 8 billion [2^34] individuals is required - giving a baseline requirement of of 2^79 bytes.

And then look at http://pages.prodigy.net/jhonig/bignum/qaearth.html Received on Tue Sep 14 2004 - 10:08:28 CDT