SELECT a.osuser,a.username,a.action, a.sid, a.serial#,b.spid, a.status,a.last_call_et,to_char(logon_time,'DD-MON HH24: MI:SS') logon_time, a.machine,
a.program FROM v$session a,v$process b
WHERE a.paddr=b.addr and sid in (select session_id from dba_ddl_locks where name =upper('DB_OBJECT_NAME'))
No comments:
Post a Comment