Showing results for 
Search instead for 
Did you mean: 
Create Post

Oracle Shared Pool

SQL Statement

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


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.

Oracle Shared Pool Size - 50pct.JPG

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎01-07-2015 04:35 AM
Updated by: