Active vs Inactive Sessions
Context: We are using Application Express version 3.0.1.00.07. We can't upgrade, because the government client won't install non-certified products on their servers, and 3.0 is the only version that's certified.
Consider two sessions.
The first session, ID 2445303193755339, is active: the user logged on, did something, and left the session idle.
The second session, ID 3900283563884807, is not active. The user logged on, did something, then logged back off.
In both cases, the apex_workspace_activity_log table shows a minimum seconds_ago value that is less than the timeout period, so it appears that both sessions are still active.
How can one tell, armed simply with the session ID value, whether or not the user has logged off?
Thanks.