Home » Other » General » Database Sizes
Database Sizes [message #103279] Wed, 16 April 2003 11:21 Go to next message
tony matos
Messages: 1
Registered: April 2003
Junior Member
Hello

I was wondering are there any set standards to define the size of a Oracle database eg(small, medium, large).

Any help on this subject would be great.

Thanks
Tony Matos
DBA Department of National Defence
Re: Database Sizes [message #103280 is a reply to message #103279] Wed, 16 April 2003 12:51 Go to previous message
Anand
Messages: 161
Registered: August 1999
Senior Member
Hi Tony,

As far as I can see, there is no fixed benchmark as to how big a database can grow. So long as you have adequate resources (memory, hard disk space, processor speed), sky is the limit for you. Once you install Oracle software, your database can be of any size.

However, you can ofcourse configure memory (SGA) according to the soze of the database you expect. You can set different values in your init.ora based on the size of the data. Eg. DB_BLOCK_BUFFER can be 8K for small databases, 16K for mid-range databases or a high value for large databases. This is due to the fact that as the database size grows, performance may become an issue. To counter this issue, you need to configure the "Oracle" memory (SGA) which is done through the init.ora file.

Hope it's clear. Pls get in touch for more info.
Previous Topic: i can't find the Instance Manager on oracle 8.1.7
Next Topic: CASE tools
Goto Forum:
  


Current Time: Fri Mar 29 06:31:33 CDT 2024