Skip to main content

Hello,

 

 

I want to instantly see active users connected to oracle. Is there any table other than fnd_client_logon_tab table?

Hi @ADNAN,
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

Check fnd_session_runtime also,  it’s based on GV$SESSION and has more information about the sessions :wink:

Reply


Terms & ConditionsCookie settings