Shulou(Shulou.com)06/01 Report--

SELECT dob.object_name table_name

Lo.locked_mode

Lo.session_id

Vss.serial#

Vss.status

Vps.spid

Vss.action action

Vss.osuser osuser

Vss.machine,-- Machine name

Vss.terminal-- Terminal

Vss.client_identifier,-- client identifier

Vss.process ap_pid

Vps.spid db_pid

'alter system kill session'

| |'|

| | lo.session_id |

| |','|

| | vss.serial# |

| |'';'|

Kill_command

FROM v$locked_object lo

Dba_objects dob

V$session vss

V$process vps

WHERE lo.object_id = dob.object_id

AND lo.session_id = vss.sid

AND vss.paddr = vps.addr

ORDER BY 2, 3, dob.object_name

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.