Friday, January 11, 2013

active session accessing any particular table


SQL> col MODULE format A35
SQL> col PROGRAM format A35
SQL> l
  1* select sid,serial#,module,program from v$session where ROW_WAIT_OBJ# in (select object_id from dba_objects where object_type='TABLE' and object_name='TABLE_TEST')
SQL> /

       SID    SERIAL# MODULE                              PROGRAM
---------- ---------- ----------------------------------- -----------------------------------
      2033      18226 SQL*Plus                            sqlplus@testdb1 (TNS V1-V3)

SQL>

No comments:

Post a Comment