Re: database size

It all depends. While 1 Gbyte is not very large by today's standards, it also depends on the workload. How many users will be accessing the database concurrently? The "small", "medium", and "large" suggestions in the default init.ora are nothing more than suggestions. For some parameters (SHARED_POOL_SIZE, etc.), the number of concurrent users makes a bigger impact than amount of data.

After initially setting up your database, you'll need to take a look at how well it is running with your current settings and modify them to tune the database.

HTH,
Brian

Robin Witkop-Staub wrote:
>
> Would you consider a 1GIG database 'small' when setting up the init.ora
> parameters?
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================