CHECK WAIT CLASS IN ORACLE DATABASE :

>> select event,p1,p2,wait_class from v$session_wait where sid=29;

EXAMPLE :

SQL> select event,p1,p2,wait_class from v$session_wait where sid=29;

EVENT                                                                    P1
---------------------------------------------------------------- ----------
        P2 WAIT_CLASS
---------- ----------------------------------------------------------------
SQL*Net message from client                                      1413697536
         1 Idle