数据库死锁语句查询

735

1页

5次

2020-03-31

5墨值下载

select last_call_et,v.event,

s.sql_id,

v.inst_id,

v.sid,

v.BLOCKING_SESSION,

v.ROW_WAIT_OBJ#,

v.row_wait_block#,

s.SQL_FULLTEXT,

s.SQL_TEXT,

'alter system kill session ''' || v.sid || ',' || v.serial# || '''

immediate;',

v.USERNAME,

s.CPU_TIME,

s.ELAPSED_TIME,

v.PROGRAM,

'kill -9 ' || p.spid,

v.CLIENT_INFO,

v.SQL_HASH_VALUE,

v.SQL_ADDRESS,

v.MACHINE,

v.TERMINAL,

s.DISK_READS,s.BUFFER_GETS,s.SORTS,s.SHARABLE_MEM,s.PERSISTENT_MEM,s.RUNTIME_MEM

,s.ROWS_PROCESSED

from gv$session v, gv$process p, gv$sql s

where v.last_call_et > 0

and v.status = 'ACTIVE'

and v.username != 'SYS'

and p.addr = v.paddr

and s.ADDRESS = v.SQL_ADDRESS

and s.HASH_VALUE = v.SQL_HASH_VALUE

and v.INST_ID=s.INST_ID

and v.INST_ID=p.INST_ID

order by last_call_et desc;

of 1

5墨值下载

关注