Query to find last logon time of DB user in 11g

on
Please use the below query to find the last logon time of DB user.

SELECT   username, 
         To_char(Max(timestamp), 'DD MON YYYY hh24:mi') logon_time 
FROM     dba_audit_trail 
WHERE    username = '&user' 
GROUP BY username 
ORDER BY logon_time, 
         username;ncurrent_queue_name FROM apps.fnd_concurrent_queues_tl);

Comments

Post a Comment