Nov 25

EM12c Database Time Spent Waiting alerts

I have an Oracle EM12c environment (version 12.1.0.3) set up to monitor my production databases. On one database, I occasionally get an alert for the ‘Database Time Spent Waiting (%)’ category. Yet I have disabled this metric in EM.

I found out that this metric is a server-side alert. Disabling in the OMS does not stop the metric from being collected by the agent on the server side. The part that I don’t understand is that if I have disabled the metric in the OMS, even if the agent informs the OMS of the problem, shouldn’t the OMS ignore it? Why do I still get the alert?

To adjust this, I had to sign on to the database in question and issue this:

begin
dbms_server_alert.set_threshold(dbms_server_alert.db_time_waiting,
dbms_server_alert.OPERATOR_GE,99,
dbms_server_alert.OPERATOR_GE,100,
60,6,
'db_name',dbms_server_alert.object_type_event_class,'Network');
end;
/

I set the alerts to have a warning threshold of 99 and critical of 100. Note in red that this is for the Network category. The possible categories are:

  • Administrative
  • Application
  • Cluster
  • Commit
  • Concurrency
  • Configuration
  • Network

It relaxes cheap viagra the blood arteries around the genital organ to allow more blood flow to cause an erection. In a day only one dose has been advised by the most tadalafil uk check for more info now physicians because of its affectivity. With today’s hectic lifestyle and mental pressure, there are several home remedies for nose blockage which are convenient to use and are quite safe to try at home without any risk cialis sale of side effect. Here is a brief review of the cialis 25mg seanamic.com hair treatment I tried.
I issued similar commands for the other categories. Now I no longer receive these alerts.

It is still frustrating that I have to take this action. I understand the concept that this is a server side alert. What I fail to see is why I still get an email. The OMS can surely be smarter than this. It should have the power to say that I received the alert but it has been disabled for this target so I’m not going to bother anyone.

bpeasland