Current Shared Pool SIze

SQL Statement

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

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


Oracle Database	Oracle_Monitoring_Tools	SQL_Tuning_Tool	Oracle Tuning	Oracle_Tuning_Tools	Oracle_Performance
Oracle Monitoring	J2EE Performance Tools	Java Performance Tuning Tools	Database Tuning	Java Application Performance	oracle_9i_tuning
Database Monitoring	Database Performance	sql_performance_tuning	9i_performance_tuning	oracle_10g_tuning	sql_2000_performance_tuning
Denver Internet Marketing from Parallel Path			sql tuning	sql server tuning