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 vote107 views1 answer
Find all tables where column name exists oracle
SQL
0 vote100 views1 answer
Group_concat only returns one row
SQL
0 vote107 views1 answer
OFFSET consulta mysql
SQL
2 votes102 views3 answers
Current month mysql query
SQL
1 vote54 views1 answer
Postgresql last element of array
SQL
3 votes107 views2 answers
Oracle sql drop sequence
SQL
3 votes53 views2 answers
Mysql sum with condition
SQL
-1 vote115 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote107 views1 answer
Flask sqlalchemy decimal
SQL
0 vote197 views1 answer
How to delete duplicate rows in oracle
SQL