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

When we share a database, we often encounter the problem of locking tables.

1. The stored procedure cannot be executed

2. The query table data appears slowly

3. The phenomenon of sticking appears at the front end

Query the data with the locked table through sql:

SELECT dob.OBJECT_NAME Table_Name,lo.SESSION_ID | |','| | vss.SERIAL# deletion number

Lo.locked_mode,lo.SESSION_ID, vss.SERIAL#,vss.action Action,vss.osuser OSUSER, vss.LOGON_TIME

Vss.process AP_PID, VPS.SPID DB_PID, vss.*

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

From command, execute the following command to close session

ALTER system kill session '1717, 6049'

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.