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

Query lock table

Select object_name,machine,s.sid,s.serial# from v$locked_object lmt dbathing objects o, v$session swhere l.object_id = o.object_id and l.session_id=s.sid

Kill table (in-program kill)

Alter system kill session '543 and 9206'

If you can't kill, you can check this to get the spid (give the acquired spid to the authorized network administrator, and he will be killed by you. This belongs to out-of-program killing. After killing this PL/SQL, you will log in again.

Select a.spidrec b.sidrecoveryb.serialauthorauthorb.username from v$process arewlegsession b where a.addr=b.paddr and b.statuswriting KILLED`

Query the spid of sid to verify whether the above query is correct

Select b.spidrecovera.osuserjour b.program from v$session a where a.paddr=b.addr and a.sid=543 vested process b

These are all the relevant knowledge points of this introduction. Thank you for your study and support.

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.