ITPub博客

  SELECT DOB.OBJECT_NAME TABLE_NAME,        LO.SESSION_ID,        VSS.SERIAL#,        VSS.ACTION ACTION,        VSS.OSUSER OSUSER,        VSS.PROCESS AP_PID,        VPS.SPID DB_PID   FROM V$LOCKED_OBJECT LO, DBA_OBJECTS DOB, V$SESSION VSS, V$PROCESS VPS  WHERE LO.OBJECT_ID = DOB.OBJECT_ID  &nbsp