RE: Higher CPU Utilisation on failover node under same workload
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <Chris.Osborne@xxxxxxxxx>, <fuzzy.graybeard@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Nov 2014 11:49:00 -0500
I would say the NULL hypothesis is that the fail over node never reaches
steady state compared to the normal production workload.
As such all the caching of sql, packages, and procedures that takes place in
the shared pool, java in the java pool, and data in the buffer cache is
burning cpu above the normal workload, EVEN if no extra user transaction
load is taking place.
A partial cure for this is included in my unwritten (likely never to be
written) book about planning for business continuation.
The synopsis relevant to you is: Mine your shared pool for stored procedures
and all the read only queries. (Planning for updating rows using canonical
special values should only be attempted at the post graduate level). Mine
your buffer cache for slowly changing objects. Build yourself a failover
startup kit that runs those procedures as soon as you start the database but
before you turn the users loose. Do all the SYS and SYSTEM owned packages
and procedures first. Remember to do the double (or more) hit and to
implement something to avoid direct read for things you want to stay in the
buffer cache.
Hmm. I wonder if I can make a 45 minute presentation out of that.
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Osborne, Chris
Sent: Thursday, November 06, 2014 10:40 AM
To: fuzzy.graybeard@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Higher CPU Utilisation on failover node under same workload
Immediate. And yes it completes successfully.
Chirs
Christopher Osborne
Lead Technical Specialist, Performance Engineering
British Sky Broadcasting
Email:chris.osborne@xxxxxxxxx
Desk: +44 1506 325069 | Mobile: +44 7720 308941
Please note new Mobile number.
oebanner4ps_gap2_620
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Hans Forbrich
Sent: 06 November 2014 14:53
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Higher CPU Utilisation on failover node under same workload
On 06/11/2014 3:13 AM, Osborne, Chris wrote:
When we fail over, it's a database shutdown,
Just to confirm - what 'kind' of shutdown are you using, and if a 'clean'
one, does it complete?
/Hans
Information in this email including any attachments may be privileged,
confidential and is intended exclusively for the addressee. The views
expressed may not be official policy, but the personal views of the
originator. If you have received it in error, please notify the sender by
return e-mail and delete it from your system. You should not reproduce,
distribute, store, retransmit, use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail communication through
our internal and external networks. SKY and the SKY marks are trademarks of
British Sky Broadcasting Group plc and Sky International AG and are used
under licence. British Sky Broadcasting Limited (Registration No. 2906991),
Sky-In-Home Service Limited (Registration No. 2067075) and Sky Subscribers
Services Limited (Registration No. 2340150) are direct or indirect
subsidiaries of British Sky Broadcasting Group plc (Registration No.
2247735). All of the companies mentioned in this paragraph are incorporated
in England and Wales and share the same registered office at Grant Way,
Isleworth, Middlesex TW7 5QD.
Other related posts:
