Re: Initial Size of Oracle Database

Al

Most of that is taken up by the SYSTEM tablespace which holds the data dictionary. I have no idea what the minimum size of a database would be (and it will differ from version to version anyway), but that's where it's going. You could create a test instance with AUTOEXTEND ON for SYSTEM tablespace and start it at 100M and increase in, say 1M chunks. Then, when catalog/catproc have run etc, see what the 'final' size of SYSTEM tablespace is. Of course, you should be sizing for the amount of data you're going to stick in - and that will be in a different tablespace anyway.

Aside to all this, I guess that if you're worried about the size of a couple of hundred mb swamping your clients, then perhaps Oracle isn't what you should be considering...?

"Al Willis" <alwillis_at_pdq.net> wrote in message news:D36111974A3E36F2.21D378F14E9E923A.68360D0226E5A2B3_at_lp.airnews.net...
> I'm very new to Oracle. Can someone please provide me with specific
> information on how to minimize the initial size of an Oracle database.
 When
> I create a database using the standard tools, it comes out to about 250 MB
> in size. This is in comparison of a typical empty MS SQL Server database
> size of 2.1 MB. My databases are typically relatively small. The largest
> table would typically have about 25,000 records of about 1200 bytes per
> record. There may be 400 tables in the database, most of them much
 smaller
> than the example that I have given. The platform is Windows NT/2000.
>
> Multiple Oracle databases the size of 250 MB would quickly swamp my
 clients
> storage capabilities.
>
> Any help is appreciated.
>
> Thanks,
>
> Al Willis
>
>
Received on Tue Apr 17 2001 - 06:41:08 CDT