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

0 vote116 views1 answer
Change date format in oracle query
SQL
0 vote113 views1 answer
View t-sql mail configuration
SQL
8 votes108 views2 answers
Phpmyadmin password
SQL
0 vote112 views1 answer
Add colum date in sql
SQL
20 votes117 views3 answers
SQL query rename table
SQL
0 vote115 views1 answer
Sql server get date of previous sunday
SQL
0 vote110 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote121 views1 answer
Sql max min
SQL
0 vote119 views1 answer
Oracle list datafiles
SQL
2 votes104 views1 answer
Can you use a where clause for a child query
SQL