From: Brian Peasland <peasland@edcmail.cr.usgs.gov>
Subject: Re: database size
Date: 2000/06/06
Message-ID: <393CFA47.75609DE5@edcmail.cr.usgs.gov>#1/1
Content-Transfer-Encoding: 7bit
Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739)
X-Nntp-Posting-Host: edcntw241.cr.usgs.gov
References: <8D__4.654$zp5.12940@news.uswest.net>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: Raytheon Systems
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.misc


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!
========================================