I am new to the DBA world, but please if you may help me in this:
I have a temporary table that is having an abnormal increase in size.
I would like that a warning message or an alert is sent to the DBA via OEM whenever the size of this table
Passes a threshold for example 3 GB
Thanks for your help
Start by reading about Incident Management in Chapter 3 of Cloud Control's Admin Guide:
Chapter 4 then addresses Notifications, which should get you what you want.