Hi gurus,
Please help me out, i can not withdraw a lock on a table ( ORACLE SERVER 8.1.6.3.0).
If i shutdown then startup it, the lock is still there.
Printable View
Hi gurus,
Please help me out, i can not withdraw a lock on a table ( ORACLE SERVER 8.1.6.3.0).
If i shutdown then startup it, the lock is still there.
It 1ce happened to me 2...
I just killed on the ongoing sessions....
and the lock was free....
try this out...
Hi
use this sql to check on the user how created the lock, and the sql statment that created that lock:
select a.object_name, b.oracle_username, b.os_user_name,c.sid, c.serial#,c.terminal, d.sql_text
from sys.dba_objects a,
v$locked_object b,
v$session c,
v$sqltext d
where a.object_id = b.object_id
and c.sid = b.session_id
and c.sql_hash_value = d.hash_value
i think that kiling a session befor you know what was the resone s not that good. so check for the couse first. if you need to kill the session, the line goes like this:
alter system kill session 'c.sid, c.serial#'
hope this helps