Users: View All Active Users

Description: View all actively connected users in the system.

SELECT COUNT(*) "ACTIVE USERS"
FROM v_$session
WHERE username IS NOT NULL;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.