Current Shared Pool SIze

SQL Statement

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

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 70 MB.

Check for Hung Monitor

For more information about Writing Custom Alerts, see PG110.