RE: Solaris T5220 server problem
From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Wed, 27 Apr 2011 17:28:41 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E120E80B74F_at_ONEWS06.oneneck.corp>
Has the problem existed for 2 years and they just didn't notice it, or did the problem just start 6 weeks ago and before that things were running faster on the same hardware? If the problem has existed since moving to the new servers, then you're most likely just facing the known issue of a major CPU bottleneck with these servers (see MOS Doc ID 781763.1, and search the archives for T2000). If the problem just started 6 weeks ago, then I'd start with researching all system changes around that time including changes in database stats, explain plans and query bind variables. Sorry, no experience with page coalescing.
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.
Date: Wed, 27 Apr 2011 17:28:41 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E120E80B74F_at_ONEWS06.oneneck.corp>
Has the problem existed for 2 years and they just didn't notice it, or did the problem just start 6 weeks ago and before that things were running faster on the same hardware? If the problem has existed since moving to the new servers, then you're most likely just facing the known issue of a major CPU bottleneck with these servers (see MOS Doc ID 781763.1, and search the archives for T2000). If the problem just started 6 weeks ago, then I'd start with researching all system changes around that time including changes in database stats, explain plans and query bind variables. Sorry, no experience with page coalescing.
Regards,
Brandon
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfson Larry - lwolfs Sent: Wednesday, April 27, 2011 5:15 PM
Server and database have been up close to 2 years and they just noticed these processes running longer about 6 weeks ago. They put a new release in TEST but claim problem started just prior to that. Not refuting that.
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 27 2011 - 19:28:41 CDT