RE: Where To Use Additional Memory
- From: Patty.Charlebois@xxxxxxxxxxxxxx
- To: Ethan.Post@xxxxxx
- Date: Wed, 8 Dec 2004 12:32:39 -0500
Agreed on all points=2E
We don't actually have a performance *problem*=2E Our response times are=20=
within our SLA=2E The only *problem* I have is a manager who budgetted for=20=
2 Gb of memory for our production server this year and insists that we=20=
somehow use it=2E :) Things are not bad, he just wants them to be better=20=
because he spent the money and he wants to see something for it=2E
I will collect some statspack reports during peak periods and post them=2E=20=
Maybe someone will see somewhere that the memory could be of use=2E
Thanks for your responses,
Patty=2E
"Post, Ethan" <Ethan=2EPost@ps=2Enet>=20=
2004/12/08 10:39 AM
To
<Patty=2ECharlebois@greenshield=2Eca>, <oracle-l@freelists=2Eorg>
cc
Subject
RE: Where To Use Additional Memory
There are many possible reasons for this=2E=2E=2E
1=2E You did not increase the size of the Oracle Buffer Cache to take
advantage of the new memory=2E
2=2E Your performance problems were already related to excessive logical
IO and adding memory will only add to the problem=2E
3=2E There is a disk/cpu or network bottleneck, no amount of new memory
will solve this=2E
4=2E Hardware isn't good at compensating for poor application design=2E
Why don't you post a few statspack reports someplace when you are having
trouble I am sure others will be happy to comment=2E Use 5-10 minute
intervals when you are having the problems=2E
-----Original Message-----
From: oracle-l-bounce@freelists=2Eorg
[mailto:oracle-l-bounce@freelists=2Eorg] On Behalf Of
Patty=2ECharlebois@greenshield=2Eca
Sent: Wednesday, December 08, 2004 9:03 AM
To: oracle-l@freelists=2Eorg
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
h=
ave
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=3D92ave=
z
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
--
http://www=2Efreelists=2Eorg/webpage/oracle-l
----------------------------------------------------------
This e-mail is confidential, intended solely for the use of the
recipient(s) to whom it was addressed=2E If you have received it
in error, please do not copy or distribute this e-mail=2E We ask
that you notify us immediately by replying to the sender and
then delete this e-mail=2E E-mail sent or received over the
internet may not be secure=2E You should use caution when sending
e-mail messages containing private and confidential information
or consider other secure means to send the information=2E 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=2E
Please visit us at our website: http://www=2Egreenshield=2Eca
----------------------------------------------------------
Ce message de courriel est confidentiel et s=92adresse uniquement
=E0 la personne ou =E0 l=92organisme indiqu=E9(e)=2E Si vous l=92avez re=E7u
par erreur, veuillez ne pas copier ni distribuer ce message de
courriel=2E Nous vous demandons de nous aviser imm=E9diatement en
r=E9pondant =E0 l=92exp=E9diteur, puis en supprimant ce message=2E Les
messages envoy=E9s ou re=E7us par courriel pourraient ne pas =EAtre
s=E9curis=E9s=2E Vous devriez =EAtre prudent lorsque vous envoyez des
messages de courriel contenant des renseignements confidentiels
et priv=E9s ou songer =E0 prendre d=92autres moyens s=E9curis=E9s pour
envoyer les renseignements=2E Si vous avez des questions concernant
l=92authenticit=E9 ou la s=E9curit=E9 d=92un courriel que vous avez re=E7u de
Green Shield Canada, n=92h=E9sitez pas =E0 communiquer avec nous au
1-800-265-5615=2E
Visitez notre site Web: http://www=2Egreenshield=2Eca
--
//www.freelists.org/webpage/oracle-l
Other related posts:
