Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Where To Use Additional Memory

RE: Where To Use Additional Memory

From: Post, Ethan <>
Date: Wed, 8 Dec 2004 09:39:15 -0600
Message-ID: <>

There are many possible reasons for this...

  1. You did not increase the size of the Oracle Buffer Cache to take advantage of the new memory.
  2. Your performance problems were already related to excessive logical IO and adding memory will only add to the problem.
  3. There is a disk/cpu or network bottleneck, no amount of new memory will solve this.
  4. Hardware isn't good at compensating for poor application design.

Why don't you post a few statspack reports someplace when you are having trouble I am sure others will be happy to comment. Use 5-10 minute intervals when you are having the problems.

-----Original Message-----
[] On Behalf Of
Sent: Wednesday, December 08, 2004 9:03 AM To:
Subject: Where To Use Additional Memory

Recently my manager stopped by my desk and asked why the additional 2 Gb=3D20=3D
of memory the Sysadmin added to the production server was not improving=3D20=3D
our OLTP transaction response time=3D2E Ok course I had no idea that any=3D20=3D
additional memory had been added to the server so I am obviously not using=3D20=3D
it for the database=3D2E=3D2E=3D2E

We are new to Oracle 9=3D2E2 (9=3D2E2=3D2E0=3D2E5) and AIX 5L = (5=3D2E2)=3D2E I have
read all=3D

about the new 'advice' catalog views and memory management in = 9i=3D2E=3D20=3D

I have a few questions:=3D20=3D

  1. How safe is it to turn on db_cache_advice during peak = transaction=3D20=3D periods?
  2. How reliable/useful are the stats that I see out of the V$ = advice=3D20=3D views?
  3. Does anyone have a tried and true method for determining the best place=3D20=3D to use additional physical free memory?

TIA=3D2E=3D2E=3D2E Patty

This e-mail is confidential, intended solely for the use of the recipient(s) to whom it was addressed=3D2E If you have received it in error, please do not copy or distribute this e-mail=3D2E We ask that you notify us immediately by replying to the sender and then delete this e-mail=3D2E E-mail sent or received over the internet may not be secure=3D2E You should use caution when sending e-mail messages containing private and confidential information or consider other secure means to send the information=3D2E If you have any questions regarding the authenticity or security of e-mail you have received from Green Shield Canada please do not hesitate to contact us at 1-800-265-5615=3D2E

Please visit us at our website: http://www=3D2Egreenshield=3D2Eca

Ce message de courriel est confidentiel et s=3D92adresse uniquement
=3DE0 la personne ou =3DE0 l=3D92organisme indiqu=3DE9(e)=3D2E Si vous =
par erreur, veuillez ne pas copier ni distribuer ce message de courriel=3D2E Nous vous demandons de nous aviser imm=3DE9diatement en r=3DE9pondant =3DE0 l=3D92exp=3DE9diteur, puis en supprimant ce = message=3D2E Les
messages envoy=3DE9s ou re=3DE7us par courriel pourraient ne pas =

s=3DE9curis=3DE9s=3D2E Vous devriez =3DEAtre prudent lorsque vous = envoyez des
messages de courriel contenant des renseignements confidentiels et priv=3DE9s ou songer =3DE0 prendre d=3D92autres moyens = s=3DE9curis=3DE9s pour
envoyer les renseignements=3D2E Si vous avez des questions concernant l=3D92authenticit=3DE9 ou la s=3DE9curit=3DE9 d=3D92un courriel que vous = avez
re=3DE7u de
Green Shield Canada, n=3D92h=3DE9sitez pas =3DE0 communiquer avec nous = au

Visitez notre site Web: http://www=3D2Egreenshield=3D2Eca

Received on Wed Dec 08 2004 - 09:41:45 CST

Original text of this message