Oracle PL/SQL/System Tables Views/DBA AUDIT SESSION

Query DBA_AUDIT_SESSION for Login time

 
SQL> select
  8    TO_CHAR(Timestamp,"DD-MON-YY HH24:MI:SS")    /*Login time*/
 10  from DBA_AUDIT_SESSION;
SQL>
SQL>

Query DBA_AUDIT_SESSION for Logoff time

 

SQL> select
  9    TO_CHAR(Logoff_Time,"DD-MON-YY HH24:MI:SS")   /*Logoff time*/
 10  from DBA_AUDIT_SESSION;
SQL>
SQL>

Query DBA_AUDIT_SESSION for Operating system username used

 
SQL> select
  2    OS_Username           /*Operating system username used.*/
 10  from DBA_AUDIT_SESSION;
SQL>
SQL>

Query DBA_AUDIT_SESSION for Oracle username of the account used

 
SQL> select
  3    Username              /*Oracle username of the account used.*/
 10  from DBA_AUDIT_SESSION;
SQL>
SQL>

Query DBA_AUDIT_SESSION for Terminal ID used

 
SQL> select
  4    Terminal              /*Terminal ID used.*/
 10  from DBA_AUDIT_SESSION;
SQL>
SQL>