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

5 votes130 views1 answer
Oracle get ddl
SQL
0 vote264 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
4 votes116 views5 answers
Primary key
SQL
3 votes98 views3 answers
Concatenation in sql
SQL
0 vote114 views1 answer
Describe in sqlite3
SQL
0 vote152 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote104 views1 answer
Postgres add prefix to primary key
SQL
6 votes158 views2 answers
How to get last element sql
SQL
15 votes106 views2 answers
How to know the username of postgresql
SQL
14 votes124 views4 answers
Online sql compiler
SQL