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 vote159 views2 answers
Laravel get sql query eloquent with parameters
SQL
1 vote179 views2 answers
Mysql does sentance contain word
SQL
6 votes164 views2 answers
Join vs union
SQL
0 vote169 views3 answers
Insert query in ci
SQL
0 vote152 views1 answer
Codeigniter 3 get best-selling products
SQL
1 vote151 views2 answers
Sql server backup table
SQL
0 vote142 views1 answer
Oracle 11g forget password
SQL
0 vote203 views1 answer
Migrations.RunSQL
SQL
0 vote156 views1 answer
Print mysql
SQL
0 vote161 views4 answers
Sql rownum
SQL