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

-1 vote272 views1 answer
Phinehas Psalm 106
SQL
7 votes258 views3 answers
Restore postgres database from sql file
SQL
4 votes253 views3 answers
Rename table column postgresql
SQL
0 vote254 views1 answer
Postgres foreign key multiple columns
SQL
0 vote241 views1 answer
Oracle query to see what scema i am working in
SQL
1 vote248 views1 answer
Search for tables with name postgresql
SQL
0 vote265 views1 answer
Check connections to database postgres
SQL
0 vote259 views1 answer
Mysql query with sql to get the next row
SQL
0 vote219 views1 answer
Update row in sqlite python
SQL
0 vote301 views1 answer
Sparql list all graphs
SQL