Re: How Large is a BIG Relational DB

From: Michael Nolan <nolan_at_helios.unl.edu>
Date: 7 Mar 1994 05:37:38 GMT
Message-ID: <2leej2$kt5_at_crcnis1.unl.edu>


ddargo_at_us.oracle.com (Dave Dargo) writes:

:aevans_at_kaiwan.com (Alan B. Evans) writes:  

:>(SVR4) using Oracle 7. Oracle 7 has a design limitation in that
:>1 instance of Oracle can only handle 256 GB of data.
 

:Most definately not correct.  More like a design limitation of around 4
:Terrabytes.  There are production databases in Oracle larger than the 256 GB
:you mention (including one on a Sun box).


Well, according to the specs for Oracle 7 for NCR Unix, you can have up to 1022 data files, each of which can have 16 million blocks. The standard block size on this system is 2048 bytes, so we have

1022*16*1024*1024*2048 or 35,115,652,612,096.

35 terabytes is larger than I currently know what to do with, but I think it is possible to use a block size of 8192 bytes, which would quadruple the above limit.

---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan_at_notes.tssi.com, dbms_at_genie.geis.com
(posted from nolan_at_helios.unl.edu)
Received on Mon Mar 07 1994 - 06:37:38 CET

Original text of this message