Re: OEM 12c (12.1.0.5) generating too many alerts on Metrics "Logons Per Sec"

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 26 Dec 2017 21:49:42 +0000
Message-ID: <MM1P12301MB1658F25AA93487C6ABDA4D50A5060_at_MM1P12301MB1658.GBRP123.PROD.OUTLOOK.COM>

Ashoke,

The correct way to fix this problem is to find out what is logging on 146 times per second and stop it - it can't possibly be necessary and it's probably having an appalling effect on the performance of the database. I'd expect to see lots of time lost on library cache latch and dictionary cache latch activity, probably with plenty of mutex sleeps as well and "connection management" showing up with a significant (though relatively small) amount of time in the Time Model report.

If you want to avoid too many messages flooding your inbox (until you've fixed the important problem) create a rule that redirects the incoming alert messages to a separate file based on the subject and some aspect of the message content.

Regards
Jonathan Lewis

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Ashoke Mandal <ramukam1983_at_gmail.com> Sent: 26 December 2017 13:17
To: Kellyn Pot'Vin-Gorman
Cc: Mladen Gogala; ORACLE-L
Subject: Re: OEM 12c (12.1.0.5) generating too many alerts on Metrics "Logons Per Sec"

Hi Kellyn, Here is the details of the alert. This alert is is coming too many times and flooding my Inbox. Any help will be appreciated. Thanks, Ashoke

Host=<Host_Name>
Target type=Database Instance
Target name=<DB_Name>
Categories=Load
Message=Metrics "Logons Per Sec" is at 149.676<https://gva04cn1.lau.medtronic.com:7800/em/redirect?pageType=sdk-core-event-console-detailEvent&issueID=600D37F6B8350327E054001B2194CD2D> Severity=Warning
Event reported time=Dec 26, 2017 6:02:38 AM MST Operating System=SunOS
Platform=sparc
Associated Incident Id=2606<https://gva04cn1.lau.medtronic.com:7800/em/redirect?pageType=sdk-core-event-console-detailIncident&issueID=613EE5C7DFBA26EDE054001B2194CD2D> Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No Associated Incident Priority=None
Associated Incident Escalation Level=0
Event Type=Metric Alert
Event name=Server_Adaptive_Threshold_Metric:instance_throughput__logons_ps Metric Group=Server_Adaptive_Threshold_Metric Metric=Cumulative Logons Per Sec<https://gva04cn1.lau.medtronic.com:7800/em/redirect?pageType=sdk-core-metric-details&timePeriod=byDay&metric=Server_Adaptive_Threshold_Metric&target=thdmas.dmas.medtronic.com&metricColumn=instance_throughput__logons_ps&type=oracle_database&keyValue=SYSTEM> Metric value=149.675702644271
Key Value=SYSTEM
Rule Name=MTC_MECC_DMAS Incident All Targets,Create incident for critical metric alerts Rule Owner=SYSMAN
Update Details:
Metrics "Logons Per Sec" is at 149.676
Incident created by rule (Name = MTC_MECC_DMAS Incident All Targets, Create incident for critical metric alerts; Owner = SYSMAN).

On Mon, Dec 25, 2017 at 8:42 PM, Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com<mailto:dbakevlar_at_gmail.com>> wrote: Can you please paste the alert you receive, editing out andy company Info here? The alert contains the data to isolate the metric. Thank you,
Kellyn

On Sun, Dec 24, 2017 at 2:16 PM Ashoke Mandal <ramukam1983_at_gmail.com<mailto:ramukam1983_at_gmail.com>> wrote: I have disabled the entire Throughput Metric (containing Cumulative Logons Per Sec) but it doesn't help and still receiving too many alerts on Metrics "Logons Per Sec".

I am still looking for help on how to turn off this alert.

Thanks,
Ashoke

On Fri, Dec 22, 2017 at 3:55 PM, Ashoke Mandal <ramukam1983_at_gmail.com<mailto:ramukam1983_at_gmail.com>> wrote: Hello Kellyn and Mladen, Thanks for your reply.

So far I found out Throughput Metric and that has Cumulative Logons Per Sec. I have disabled the entire Throughput Metric and will see if that stops this warning alert. under Oracle Database -> Monitoring -> All Metrics -> Throughput

Ashoke

On Fri, Dec 22, 2017 at 1:14 PM, Mladen Gogala <gogala.mladen_at_gmail.com<mailto:gogala.mladen_at_gmail.com>> wrote: The most probable cause is having both OEM with Grid Control DB and a local EM running. Regards

On Fri, 22 Dec 2017 09:43:32 -0600
Ashoke Mandal <ramukam1983_at_gmail.com<mailto:ramukam1983_at_gmail.com>> wrote:

> Dear All,
>
> I have migrated some of our databases from OEM 11g to OEM 12c (12.1.0.5).
> It working OK but getting too many extra warning like this.
>
> EM Event: Warning:thdmas.dmas.medtronic.com<http://thdmas.dmas.medtronic.com> - Metrics "Logons Per Sec" is
> at 105.409
>
>
> I would like to disable this but not able to locate the related metric in
> 12c OEM console.
>
> I logged into the database via OEM 12C and checked under the following area
> but not able to find the Metrics "Logons Per Sec" .
>
> Oracle Database -> Monitoring -> Metric and collection settings
>
> Oracle Database -> Monitoring -> All Metrics
>
> Any help will be highly appreciated.
>
> Thanks,
> Ashoke

--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217<tel:%28347%29%20321-1217>


--
<http://about.me/dbakevlar>

[Kellyn Pot'Vin on about.me]

Kellyn Pot'Vin-Gorman
about.me/dbakevlar



--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 26 2017 - 22:49:42 CET