Description

This custom Ignite alert calculates the current size of the Oracle shared pool and sends an alert to "All DBAs" if it's larger than 180 MB and to the "On Call" DBAs if it grows to over 200 MB.

SQL statement

select round(sum(sharable_mem)/1024/1024) from v$sqlarea

Ignite alert definition