Very Computer

Can anyone tell the size limit of an Oracle database (7.1, 7.2, and 7.3)?
Can it be in tera-byte order?

I tried to look at Oracle web site, but found a big mess there: many pages
are missing in Product Info, and the esarch engine shows lots of lost
links. I could not allocate any data sheet for Oracle7.

John Cai

Hi:

Depends on the operating system.  Check your O/S specific guide.

Good luck,
Dave

The maximum size in Oracle7 is determined by

Maximum number of files : 1023 files
Maximum number of blocks per file : 4,000,000 (but many filesystem are
limted to 2Gb files)
Maximum block size : 16k (on most platforms)

So in theory that gives you : 1023 * 4,000,000 * 16k = 65,472 Gb
This figure is alot larger in Oracle8 where you can have 1022 tablespaces
and 1023 files per tablespace (I think that gives 4Pb ? )

Regards
David Russell

Quote:> So in theory that gives you : 1023 * 4,000,000 * 16k = 65,472 Gb
> This figure is alot larger in Oracle8 where you can have 1022 tablespaces
> and 1023 files per tablespace (I think that gives 4Pb ? )

I think, Oracle8 has a maximum datafile-size of 32 GB. You can have 1022
datafiles per tablespace. This is about 32 TB per tablespace. I don't
know if there is a limit on the number of tablespaces. If it is really
1022 as you write, you could put about 32 PB into you database...

Greeting,
Peter Buzanits
ETM Austria