RE: Where To Use Additional Memory
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <Patty.Charlebois@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Dec 2004 09:39:15 -0600
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-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Patty.Charlebois@xxxxxxxxxxxxxx
Sent: Wednesday, December 08, 2004 9:03 AM
To: oracle-l@xxxxxxxxxxxxx
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
=3D20=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 =
l=3D92avez
re=3DE7u
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 =
=3DEAtre
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
1-800-265-5615=3D2E
Visitez notre site Web: http://www=3D2Egreenshield=3D2Eca
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: