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

2 votes367 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote356 views1 answer
Foreign key type uniqu mysql
SQL
0 vote368 views2 answers
Get item by composite primary key mysql
SQL
0 vote353 views1 answer
Consulta alias con inner join
SQL
10 votes331 views2 answers
Reset mysql root password mac
SQL
1 vote338 views1 answer
Alter constraint postgres
SQL
0 vote653 views1 answer
How to connect .sql data set to powerbi
SQL
3 votes356 views1 answer
Oracle list dates without weekends
SQL
0 vote358 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote345 views1 answer
How to define a save method in ruby for sql databases
SQL