Re: Will more memory help performance?

The obvious answer is yes, but how much of a help will it be? Questions like this, require a DBA. Due to the lack of time I have, I will give you a short answer: You can estimate how much of a performance gain (Buffer Cache hit Ratio) you will get by adding additional buffers in your database by using the db_block_lru_extended_statistics utility. This utility will tell you what your Buffer Cache Hit ratio will be if you increase the db_block_buffer parameter by by n (where n is some number).

Look into this utility, and if you still have questions, e-mail me and I will try to help you out.

Good Luck,
Satar

In article <363401A2.422083DD_at_mts.net>,   Darrell & Janine Brown <nexgenco_at_mts.net> 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.
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 26 1998 - 18:36:47 CST