Re: How Large is a BIG Relational DB

Posted in 1994

Michael Nolan — 7 Mar 1994 05:37:38 GMT — source: Informix-list mailing list archive (1991-1998)

ddargo@us.oracle.com (Dave Dargo) writes: :aevans@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@notes.tssi.com, dbms@genie.geis.com (posted from nolan@helios.unl.edu)