Snippet Name: USER active connected users Description: Query for active connected users. Also see:» USER: connection information » USER: User Information 2 » USER idle time » USER Information » USER memory use » USER: Connected Users » USER: drop user » USER: misc queries and commands » USER system authentication » USER lock account » USER password expiration » USER profile » USER tablespace quota » USER temp tablespace » USER tablespace » USER password » USERS: view specific user info » USERS: view currently connected users » USERS: view all active users » USERS: Drop users » USERS: Lock and Unlock accounts » USERS: Proxy Users » USERS: Grant tablespace access » USERS: Alter a user » USERS: CREATE USER w/ authentication » USERS: Creating Users » CREATE USER » Drop User example » Create User example » Create User Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
Description: Query for active connected users.
Also see:» USER: connection information » USER: User Information 2 » USER idle time » USER Information » USER memory use » USER: Connected Users » USER: drop user » USER: misc queries and commands » USER system authentication » USER lock account » USER password expiration » USER profile » USER tablespace quota » USER temp tablespace » USER tablespace » USER password » USERS: view specific user info » USERS: view currently connected users » USERS: view all active users » USERS: Drop users » USERS: Lock and Unlock accounts » USERS: Proxy Users » USERS: Grant tablespace access » USERS: Alter a user » USERS: CREATE USER w/ authentication » USERS: Creating Users » CREATE USER » Drop User example » Create User example » Create User
SELECT COUNT(*) "ACTIVE USERS" FROM v_$session WHERE username IS NOT NULL;
