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

27 votes136 views5 answers
Add column in table
SQL
0 vote124 views2 answers
How to start postgresql laravel
SQL
0 vote211 views1 answer
Postgresql powershell query
SQL
0 vote174 views1 answer
Plpgsql create function
SQL
0 vote153 views1 answer
Find duplicate users by email address in mysql
SQL
-1 vote150 views2 answers
Import data from excel to sql server automatically
SQL
0 vote154 views1 answer
Postgresql list extensions
SQL
0 vote147 views3 answers
Sql delete all except
SQL
0 vote139 views1 answer
How to start my sql server on mac
SQL
2 votes150 views2 answers
Install sqlalchemy
SQL