Oracle ora-00054 how to unlock

alter system kill session 'sid,serial#'; --`sid` and `serial#` get from step 1

Source: stackoverflow.com

Oracle ora-00054 how to unlock

select object_name, s.sid, s.serial#, p.spid 
from v$locked_object l, dba_objects o, v$session s, v$process p
where l.object_id = o.object_id and l.session_id = s.sid and s.paddr = p.addr;

Source: stackoverflow.com

Similar codes

0 vote155 views1 answer
Pgadmin save data greyed out
SQL
0 vote135 views1 answer
Html css mobile menu arrow dropdown
SQL
4 votes138 views3 answers
Sql drop primary key
SQL
0 vote137 views1 answer
Mysql update from select on same table
SQL
1 vote138 views1 answer
Set statiscis on in ssms
SQL
0 vote189 views1 answer
How to rename a database in tsql
SQL
-1 vote138 views1 answer
Module operator in oracle sql
SQL
0 vote139 views1 answer
Into operator in sql
SQL
0 vote120 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote147 views2 answers
Sql queries practice
SQL