RE: EM12c false alarms for blocking locks
- From: Peter Sharman <pete.sharman@xxxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx, Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 31 Aug 2012 21:48:25 -0700 (PDT)
Hey Rich, sorry for the delay in responding, Kellyn's been keeping me busy
writing the architecture chapter for our book. ;)
Are you still having issues with the blocking locks and CPU wait spikes you've
mentioned on the list in the past week or two? I might have a minute or two to
look into it before life gets crazy again, this time with my eldest daughter's
21st!
Pete
Pete Sharman
Principal Product Manager
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: +61262924095 | | Fax: +61262925183 | | Mobile: +61414443449
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not, it's much harder than that!"
Bruce Pihlamae, long term Oracle DBA
-----Original Message-----
From: Rich Jesse [mailto:rjoralist2@xxxxxxxxxxxxxxxxxxxxx]
Sent: Monday, 20 August 2012 11:24 PM
To: Oracle L
Subject: EM12c false alarms for blocking locks
Hey all,
Lately EM12c has been alarming me with false alarms on the Blocking Session
Count metric. It's collecting the metric every minute and even though I keep
cranking up the "Number of Occurrences" value from 1, 2, 3, and 5, it still
keeps alarming a few times per day (and night!).
The target DB has never had a locking issue. And when I investigate the new
block, it's gone. The offending processes are everything from LGWR, PQs, and
regular user sessions. It seems like it's alarming for some "benign"
lock (e.g. shared) and ignoring the number of occurrences. It's also only
started since I installed the BP1 EM12c patch, although not immediately after
the install. I just upgraded the target DB from 10.1.0.5 to 11.2.0.3 (yay!),
and there's no change in the pattern.
Anyone else seeing this? I've got too many SRs open already... :)
TIA!
Rich
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
