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

31 votes334 views3 answers
Sql count
SQL
0 vote400 views1 answer
Stratified sampling sql
SQL
0 vote300 views1 answer
Mitigation of sql injection
SQL
0 vote364 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote396 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote381 views1 answer
How to create notes in mysql
SQL
0 vote336 views1 answer
T-sql check if data exists
SQL
15 votes344 views2 answers
Sql order by multiple columns
SQL
5 votes329 views3 answers
Truncate function in sql oracle
SQL
3 votes367 views1 answer
Postgres kill running query
SQL