RE: Setting oracle SGA and other params for large memory boxes
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: "Pradeep.Chetal@xxxxxxxxxxxxxx" <Pradeep.Chetal@xxxxxxxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>, Brandon.Allen@xxxxxxxxxxx
- Date: Tue, 10 Nov 2009 18:06:59 -0800 (PST)
"... what is the best place to use the additional memory"
Dear Pradeep,
Please send any extra memory that you're not sure what to do with to me, here
in the lovely state of Colorado. My 4-10TB data marts on two servers will make
very good use of it! :)
Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
"Go away before I replace you with a very small and efficient shell script..."
--- On Tue, 11/10/09, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
From: Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>
Subject: RE: Setting oracle SGA and other params for large memory boxes
To: "Pradeep.Chetal@xxxxxxxxxxxxxx" <Pradeep.Chetal@xxxxxxxxxxxxxx>, "ORACLE-L"
<oracle-l@xxxxxxxxxxxxx>
Date: Tuesday, November 10, 2009, 1:41 PM
I’d say just give Oracle as much as it needs for good performance but avoid
giving it excessive amounts because that will make it more difficult to free up
that memory in the future if another instance or application comes along that
needs it, plus larger SGAs have higher overhead for latches, searching all the
buffers, etc. Your SGA and PGA advice views can usually give you a good idea
of how big they should be.
Regards,
Brandon
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Pradeep Chetal
We have some new DB systems with larger memory - around 64 GB.. Since these are
dedicated DB Servers, what is the best place to use the additional memory
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
