How to check last user login Oracle

While performing database audits, you might need to check who logged in last into the database. The query will help you find out last user who logged in to database

select username, timestamp, action_name from dba_audit_session where action_name='LOGON' and
rownum<10 and username not in ('SYS','DBSNMP','DUMMY','SYSTEM','RMAN');


Jenkins interview questions

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.