| Database Sizes [message #103279] |
Wed, 16 April 2003 11:21  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
