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>