Monday, January 31, 2011

Session/Table Unlock script:

select object_name, object_id
from dba_objects
where object_id in (select object_id
from v$locked_object);

select substr(username, 1, 10),
sid,
serial#
from v$session
where sid in (select session_id
from v$locked_object
where object_id = 981549)

alter system kill session '175,3262';

1 comment:

GAMESH TAWADE said...

Very nice product so powerful and best build quality is very good.

Clicking here