Oracle Probleme: Unterschied zwischen den Versionen

Version vom 16. März 2018, 11:04 Uhr

1 Gesperrte Tabellen entspereen

2 SID der gesperrten Tabelle ermitteln

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 = 'b_auftrcol';

Output :

SID
___
607

3 ID der gesperrten Tabellenzeile ermitteln

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

4 Session beenden, die die Zeile sperrt

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';

http://www.dba-oracle.com/t_remove_oracle_table_row_lock.htm

5 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';