Toad World® Forums

email notification using oracle spotlight


#1

I would like to configure email notification using oracle spotlight for high cost sql running against database.


#2

Hi RZalavadia,

Spoltight on Oracle has alarms for general DB issues like CPU/Memory/IO, but not have alarm for specific high cost SQL, so not able to configure that email notification. You can always go to TOP SQL drilldown to check the most resource cost SQL.

Regards,

Keven Wen


#3

I don’t think it’s possible to create email notifications.