Oracle PL/SQL/System Tables Views/V SESSION

Blocked-session details

    
SQL>
SQL> select sid, blocking_session, username, blocking_session_status,
  2  program, event, seconds_in_wait
  3  from v$session
  4  where blocking_session_status = "VALID";
no rows selected
SQL>

Dynamic Performance Views: V$SESSION contains information about each connected user or process in the database

    
SQL>
SQL> select sid, serial#, username, program from v$session
  2  where username = "HR";
no rows selected

Select the default value from V$SESSION.CLIENT_INFO.

    
SQL> SELECT   USERENV("CLIENT_INFO")
  2  FROM     dual;
USERENV("CLIENT_INFO")
----------------------------------------------------------------
1
1 row selected.
SQL>
SQL>