SELECT
distinct
ss.program "SOFTWARE",
SS.TERMINAL,
ss.username "USER",
'alter system disconnect session ''' || ss.sid || ',' || ss.serial# || ',@' || ss.inst_id || ''' immediate;'
fROM gv$process pr, gv$session ss, gv$sqlarea sqa,
(select sid
from gv$lock
where id1 = (
select object_id
from dba_objects
where owner = 'LDBO'
and object_name = 'TBLTEMPTRADESTATUS'))tbllock
WHERE pr.addr = ss.paddr
AND ss.username is not null
AND ss.sql_address = sqa.address(+)
AND ss.sql_hash_value = sqa.hash_value(+)
and ss.inst_id=pr.inst_id
and ss.sid = tbllock.sid
;
No comments:
Post a Comment