Oracle PL/SQL Tutorial/System Tables Data Dictionary/DBA AUDIT SESSION

Query DBA_AUDIT_SESSION for Login time

   <source lang="sql">

SQL> select

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

SQL> SQL></source>

Query DBA_AUDIT_SESSION for Logoff time

   <source lang="sql">

SQL> select

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

SQL> SQL></source>

Query DBA_AUDIT_SESSION for Operating system username used

   <source lang="sql">

SQL> select

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

SQL> SQL></source>

Query DBA_AUDIT_SESSION for Oracle username of the account used

   <source lang="sql">

SQL> select

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

SQL> SQL></source>

Query DBA_AUDIT_SESSION for Terminal ID used

   <source lang="sql">

SQL> select

 4    Terminal              /*Terminal ID used.*/
10  from DBA_AUDIT_SESSION;

SQL> SQL></source>