RE: Where To Use Additional Memory
- From: "Johnson, George" <GJohnson@xxxxxxx>
- To: "'Patty.Charlebois@xxxxxxxxxxxxxx'" <Patty.Charlebois@xxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 8 Dec 2004 15:24:59 -0000
"why the additional 2 Gb=20= of memory the Sysadmin added to the
production server was not improving=20= our OLTP transaction response
time=2E"
That's the best one in ages!
You can't just throw memory at databases and expect them to speed
up, 10 fold. You need your ER/DB Architect to look at the DB design, gather
and check the performance stats, visit the SQL developers, look at their
code and response times, finally look at where measurable improvements will
make a difference and utilise the extra memory. Simply "tinkering" with a
limited set of the database parameters to utilise memory, will not improve
it's performance.
I had a similar problem with developers here, who kept asking why we
didn't increase the shared pool every time a piece of SQL or structure
change did not perform as well as expected. We'd upgrade the box to keep our
HW agreements up to date and they'd ask why it wasn't running faster. I
asked them to go to Asktom.oracle.com and look up "increase shared pool",
they left me alone once they had better ideas about tuning and improving
their code.
Kind regards
-----Original Message-----
From: Patty.Charlebois@xxxxxxxxxxxxxx
[mailto:Patty.Charlebois@xxxxxxxxxxxxxx]
Sent: 08 Dec 2004 15:03
To: oracle-l@xxxxxxxxxxxxx
Subject: Where To Use Additional Memory
Recently my manager stopped by my desk and asked why the additional 2 Gb=20=
of memory the Sysadmin added to the production server was not improving=20=
our OLTP transaction response time=2E Ok course I had no idea that any=20=
additional memory had been added to the server so I am obviously not
using=20= it for the database=2E=2E=2E
We are new to Oracle 9=2E2 (9=2E2=2E0=2E5) and AIX 5L (5=2E2)=2E I have
read all= =20= about the new 'advice' catalog views and memory management in
9i=2E=20=
I have a few questions:=20=
1) How safe is it to turn on db_cache_advice during peak transaction=20=
periods?
2) How reliable/useful are the stats that I see out of the V$ advice=20=
views?
3) Does anyone have a tried and true method for determining the best
place=20= to use additional physical free memory?
TIA=2E=2E=2E
Patty
----------------------------------------------------------
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
****************************************************************************
This message contains confidential information and is intended only
for the individual or entity named. If you are not the named addressee
you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received
this e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed, arrive
late or incomplete, or contain viruses. The sender therefore does not
accept liability for any errors or omissions in the contents of this
message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version.
This message is provided for informational purposes and should not
be construed as an invitation or offer to buy or sell any securities or
related financial instruments.
GAM operates in many jurisdictions and is
regulated or licensed in those jurisdictions as required.
****************************************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
