Oracle PL/SQL/System Tables Views/V SESSION
Blocked-session details
<source lang="sql">
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>
</source>
Dynamic Performance Views: V$SESSION contains information about each connected user or process in the database
<source lang="sql">
SQL> SQL> select sid, serial#, username, program from v$session
2 where username = "HR";
no rows selected
</source>
Select the default value from V$SESSION.CLIENT_INFO.
<source lang="sql">
SQL> SELECT USERENV("CLIENT_INFO")
2 FROM dual;
USERENV("CLIENT_INFO")
1 1 row selected. SQL> SQL>
</source>