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 vote328 views1 answer
No query unable to fetch row sqlite
SQL
0 vote329 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote322 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
1 vote331 views4 answers
Psql check tables command
SQL
0 vote341 views1 answer
Firebase sql
SQL
0 vote314 views1 answer
Import big data to mysql
SQL
1 vote314 views1 answer
Show per page table in xampp
SQL
32 votes341 views6 answers
Insert select
SQL
0 vote324 views1 answer
Mysql c commands
SQL
22 votes389 views1 answer
Mysql workbench
SQL