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

3 votes244 views4 answers
Psql list tables in schema
SQL
0 vote245 views1 answer
Sql server list table sizes
SQL
1 vote242 views1 answer
Sql how to duplicate a table
SQL
1 vote227 views1 answer
Oracle list datafiles in tablespace
SQL
1 vote254 views1 answer
Altrer name column postgres
SQL
0 vote216 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote234 views1 answer
Update view sql
SQL
0 vote239 views1 answer
Mysql in clausule string array
SQL
0 vote250 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote224 views1 answer
How to find top 3 salary in sql
SQL