OEM Notifications for Long Running Queries and MViews not Refreshed
Date: Tue, 22 Nov 2016 17:09:18 +0000
Message-ID: <SN2PR03MB24154F70BF2D9D4032F62BD198B40_at_SN2PR03MB2415.namprd03.prod.outlook.com>
OEM gurus,
We intend to configure OEM to be able to notify us whenever there are long running SQL or long running jobs. Please see below. We are using Enterprise Manager Cloud Control 12c. Can this be done in a very busy system? If so, can someone share the best way to do this? On the other hand, we would like to be notified whenever MViews refresh stalls for an hour. Currently we are using notification from alert log. This has worked but only when ORA- errors are generated. Any recommendation would be appreciated especially from shops heavily using OEM for notification. Kellyn Pot'Vin-Gorman, if I am not wrong, this is your area of expertise. I remember you from RMOUG when I gave presentation in 2013. Unfortunately, Houston does not have the level of involvement Denver had.
[cid:image005.jpg_at_01D244B0.DD9D4490]
[cid:image006.jpg_at_01D244B0.DD9D4490]
Thanks and best regards,
Bill
Valued Quality. Delivered.
CONFIDENTIALITY NOTICE
This e-mail may contain confidential or privileged information, if you are not the intended recipient, or the person responsible for delivering the message to the intended recipient then please notify us by return e-mail immediately. Should you have received this e-mail in error then you should not copy this for any purpose nor disclose its contents to any other person.
Intertek is dedicated to Customer Service and welcomes your feedback. Please visit http://www.intertek.com/email-feedback/ to send us your suggestions or comments. We thank you for your time.
Except where explicitly agreed in writing, all work and services performed by Intertek is subject to our Standard Terms and Conditions of Business which can be obtained at our website: http://www.intertek.com/terms/ Should you have any difficulty obtaining these from the web site, please contact us immediately and we will send a copy by return.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 22 2016 - 18:09:18 CET
(image/jpeg attachment: image005.jpg)
(image/jpeg attachment: image006.jpg)