Oracle Probleme: Unterschied zwischen den Versionen

Version vom 16. März 2018, 10:45 Uhr

Gesperrte Tabellen entspereen

STEP 1: To identify the SID for the table with the lock, you will use this system ID in a later query to get the serial number for the table row lock:

select

  session_id

from

  dba_dml_locks

where

  name = 'EMP';

Output :

SID ___ 607

STEP 2: The next step is a script to find the Serial# for the table row lock :

select

  sid,
  serial#

from

  v$session

where

  sid in (
  select
     session_id
  from
     dba_dml_locks
  where
     name = 'EMP');

Output :

SID SERIAL#

607 1402

STEP 3: Finally, we can use the "alter system" command to kill the session that is holding the table lock:

alter system kill session 'SID,SERIALl#';

alter system kill session '607,1402';