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

2 votes345 views1 answer
Datefromparts mssql
SQL
2 votes288 views1 answer
Query to find table size in oracle 12c
SQL
0 vote287 views1 answer
Sql recherche nom prenom
SQL
1 vote305 views2 answers
Find nth highest salary of an employee
SQL
0 vote338 views1 answer
Select * from mysql.proc
SQL
0 vote294 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
6 votes284 views1 answer
To count number of rows in SQL table
SQL
16 votes351 views1 answer
Mysql mediumint max value
SQL
0 vote314 views1 answer
Sql filter rows with condition
SQL
2 votes317 views1 answer
Oracle to_char number format percentage
SQL