Dynamic Performance Views: V$SESSION contains information about each connected user or process in the database : V_SESSION « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. V_SESSION

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

   
    
    
    
  

Related examples in the same category