Hello,
I want to instantly see active users connected to oracle. Is there any table other than fnd_client_logon_tab table?
Question
On Users List
+8Adnan YILMAZ
+30Hi
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
+22Check fnd_session_runtime also, it’s based on GV$SESSION and has more information about the sessions 
DSJ - https://dsj23.me
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.