Query DBA_AUDIT_SESSION for Login time : DBA_AUDIT_SESSION « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. DBA_AUDIT_SESSION
SQL> select
  8    TO_CHAR(Timestamp,'DD-MON-YY HH24:MI:SS')    /*Login time*/
 10  from DBA_AUDIT_SESSION;
SQL>
SQL>








30.27.DBA_AUDIT_SESSION
30.27.1.Query DBA_AUDIT_SESSION for Login time
30.27.2.Query DBA_AUDIT_SESSION for Logoff time
30.27.3.Query DBA_AUDIT_SESSION for Operating system username used
30.27.4.Query DBA_AUDIT_SESSION for Oracle username of the account used
30.27.5.Query DBA_AUDIT_SESSION for Terminal ID used