Re: Will more memory help performance?

More memory - not necessarily.

Performance depends on a whole lot of stuff. First of all you must have a clear idea of what you are trying to achieve. For example, if you increase ths size of your SGA to cache more of the database in memory, you will use more memory and checkpoints will take longer.

Also bear in mind that the volumne of the data has a major effect on the performance of a SQL statement.

To get started, run the SQL scripts BSTAT and ESTAT for a particular time and this will give you a snapshot of the performance across the entire database. You can then determine what you need to do to increase performance.

GM

Darrell & Janine Brown wrote:

> I work in a Data Warehouse.
>
> We currently have a quad-pentium 200 w/ 1 GB RAM running WinNT 4. We are
>
> using Oracle 7.3 with parallel server/parallel query options. The
> database takes up 60GB of a 90GB Raid array.
>
> We have the opportunity to obtain a second GB of RAM (redeployed from
> another server)
> Will the addition of the extra memory produce a noticible difference?
> Where can I find information on the degree of difference?
>
> Thanks in advance.
>
> Darrell Brown
> Programmer-Analyst
> MTS Communications Inc.
Received on Mon Oct 26 1998 - 13:02:57 CST