Re: Will more memory help performance?

In article <7134iv$hch$1_at_nnrp1.dejanews.com>,   satar_at_my-dejanews.com wrote:
> 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

db_block_lru_extended_statistics is an init.ora parameter and NOT a utility. This parameter when set TRUE enables utilities such as TKPROF generate statistics on CPU usage!
Correct me if I am wrong, please.
mvempati

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

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 27 1998 - 14:35:40 CST