Re: What is maximum size of an Oracle data base?
Date: 1996/10/14
Message-ID: <3262c651.35211648_at_news.goodnet.com>#1/1
Bob Withers (bwit_at_pobox.net) wrote:
> Can anyone tell me what the maximum size of a single Oracle data base is?
> I heard once that it was 250MB but then I hear people talk about multi-
> gig data bases. Is that a single data base or multiple linked data
> bases? I sure appreciate it is someone could clear this up for me.
>
> Thanks much,
> Bob
>
There are several different size limitations of an Oracle database,
depending on which platform (Operating system) you plan on using.
There are limitations on anount of memory you may use to run the
database. There are limitations to the size of individual objects
inside of the database. And there are limitations to the size of
datafiles that make up the database itself.
The limitations seem to vary depending on which operating system
you are going to use. While I am unable to qoute any of the exact
size limitations, we might be able to figure it out in a few days
if we new which version of your operating system and which version
of Oracle you plan on using.
If you are using any new operating system (SCO Unix Open Server,
Solaris, NT) and any recent version of Oracle (later than version 5)
you will probably never run into any problems. The only problems I
have ever seen can be solved by good planning before creating the
database. For example in the create database statement you can
allocate different file sizes for different tablespaces, online
redo logs, and dozens of other variables. Tablespaces can also
grow by adding datafiles to them.
Individual objects inside of the database like tables and indexes
have storage parameters which affect the size of the object. When
you create objects like tables you can specify how much storage
an object will use by specifying its storage parameters.
For example "storage (initial 100m next 10m pctincrease 0)".
You can also specify the maximum number of extents an object
can use. If you don't specify an objects storage parameters,
it will inherit the defaults from the tablespace that it is in.
- ========= ========= ========= ========= Noah Monsey noah_at_indirect.com
- ========= ========= ========= ========= The only dumb question is the one that you don't ask.
- ========= ========= ========= ========= Oracle Master Database Administration, April 1992 Oracle Master Application Development, April 1992
- ========= ========= ========= =========