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