Session Check

====================================

To Check which user is running which session and their status..

SQL> select status,sid,username from v$session;

=====================================


=====================================

To check the stutus of the session along with their login time

SQL> select status,sid,to_char(logon_time,'DD-MON-YYYY:HH:MI:SS') from v$session;

=======================================


=======================================

To check the login time of the session of that particular user

SQL> select status,sid,to_char(logon_time,'DD-MON-YYYY:HH:MI:SS'),username from v$session where username='SDMFPR';

========================================


========================================

To check the event of all that sid which we got earlier

SQL>  select event from v$session_wait where sid in (7,9,10,11,14);

=========================================