Hi guys,
How to find about any user from sysdba, when a user was last active on connection ??
Suppose user SCOTT logon time is 10:00 AM and he is INACTIVE ( SELECT UserName,STATUS,SID,SERIAL# FROM V$SESSION) @ 11:00 AM.
I want to know his last activity, like when he fired any query last time .
Thanks in advance