select * from sysprocesses where status in ('runnable','running')
Counts the number of user sessions currently connected to the database and alerts the "DBAs" when that exceeds 100.
Oracle | SQL Server | DB2 | Sybase