Hello,
I want to instantly see active users connected to oracle. Is there any table other than fnd_client_logon_tab table?
On Users List
Userlevel 5
+8
Userlevel 7
+30
Hi
You can also use SELECT * FROM GV$SESSION which will give you database session details.
I found a similar post @ https://community.ifs.com/ifs-technology-employees-partners-only-109/query-application-usage-876.
Best Regards,
Yasas
Userlevel 7
+20
Check fnd_session_runtime also, it’s based on GV$SESSION and has more information about the sessions 
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.