In theory, Oracle can handle 512 Picobytes (or roughly
512,000 Terabytes) for Oracle 8i.
Have not heard if this has been increased for 9i.
-----Original Message-----
From:
MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 8:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Largest Oracle Databases
One of the smaller Physics projects, GLAST (Gamma-ray Large
Area Space Telescope) is looking at storing their data in
Oracle. The bulk of thge data will be a sky map of individual photons,
about 20 terabytes, acquired at a rate of about 1 TB a year. What size
is the largest Oracle database at present? I believe Oracle should be
able to handle this, but I'd like to know if anyone has approached this
size. I hear rumors of Oracle databases of hundreds of terabytes
at the CIA, but I have no way to confirm them.
---------------------------------------------------------------------------------------------------------------------
Offtopic
I wrote a little while ago about CERN considering Oracle for
LHC project, and needing a petabyte database. It turns out that
the number was incorrect. The petabyte that was tossed around a few
years ago would be for online and secondary storage only. I don't know
their needs for tertiary storage, but our little project here , called
Babar, which is expected to store half a petabyte of data in online and
nearline storage is sized to 300 petabytes when tertiary storage is
included. The 0.5 petabytes for online and nearline will probably be
upped. If LHC has the same relationship between tertiary and
online/nearline storage, then they will need something which can handle
about 600 petabytes. Last week I attended a meeting on a project
called SuperBabar. Data estimates of size for that one are one
exabyte. I'm sure there are others in the works which will make
SuperBabar look tiny. The mind boggles.
Babar is not in Oracle and I don't expect SuperBabar will be
either.
Ian MacGregor
Stanford Linear
Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L
FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051
San Diego,
California -- Public Internet
access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru') and in
the message BODY,
include a line containing: UNSUB ORACLE-L
(or the
name of mailing list you want to be removed from). You may
also send the HELP command for other information (like
subscribing).