How to solve ORA-04021: timeout occurred while waiting to lock object

Compile an object can give the following error Quire the process to find the session that still running select a.object, a.type, b.sid,b.serial#,s.inst_id, b.username, b.osuser, b.program, s.status, s.sql_exec_start from v$access  a, v$session b, gv$session s where a.sid    = b.sid and a.owner  = DECODE(UPPER(‘&1’), ‘ALL’, a.object, upper(‘&1’)) and a.object = DECODE(UPPER(‘&2’), ‘ALL’, a.object, upper(‘&2’)) and b.sid =…
Leggi tutto

11 Marzo 2019 0