Sql

Search

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;

Comment

oracle ora-00054 how to unlock

alter system kill session 'sid,serial#'; --`sid` and `serial#` get from step 1

Comment

PREVIOUS	NEXT

Code Example
Sql :: demmarrer un service mysql teminal cmd
Sql :: mysql sublime build system
Sql :: array aggre distinct postgres
Sql :: Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
Sql :: devilbox mysqldump
Sql :: sql get actual fiscal year
Sql :: union syntax in oracle
Sql :: grant select mysql
Sql :: copy data from one postgres container to another
Sql :: compare field sql server
Sql :: case construct in where clause
Sql :: Postgres format number to 2 decimal places
Sql :: collation in sql
Sql :: oracle insert from select
Sql :: stuff in sql server
Sql :: oracle create index if not exists
Sql :: sql revert migration
Sql :: sql where clause
Sql :: longtext sql
Sql :: add column first position mysql
Sql :: postgres trim string
Sql :: sql constraint to check date less than current date
Sql :: grab part of a string sql
Sql :: sql: extract day text from datetime value
Sql :: select query in sql
Sql :: table users
Sql :: grant sql
Sql :: update table sql
Sql :: How to automatically export database to a csv file
Sql :: one to many sql

Search

SQL

oracle ora-00054 how to unlock

oracle ora-00054 how to unlock

ADD CONTENT