I have a requirement to forced a user to log out if their sessions is past the 5 hour mark. This is assuming they are doing stuff without hitting the timeout mark of 30 mins.
I know there is a table called "v_user_session", but it looks like that is only for certain nodes and not all nodes (doesn't list all users across all of the nodes). There is another table called "sys_user_session" which list out all sessions, but it doesn't tell me when they last logged off.
Any help or ideas on this one?
