SQL Statement

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

Description

This custom 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.