Number of Oracle Sessions

SQL Statement

select count(1) from v$session@#DBLINK# s, v$process@#DBLINK# p
where s.paddr = p.addr and nvl(p.background,0) <> 1

This custom alert counts the number of user sessions currently connected to the database and alerts the "DBAs" when that exceeds 100

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