top of page

BLOQUEOS

 

select 
   blocking_session, 
   sid, 
   serial#, 
   wait_class,
   seconds_in_wait,
   status,
   BLOCKING_SESSION_STATUS
from 
   v$session
where 
   blocking_session is not NULL
order by 
   blocking_session;

Sesiones Bloqueadas

select  

 va.sid, va.owner, va.object,  va.type,  ss.username, ss.status,  ss.machine,  ss.program,      ss.client_info
from v$access va, 
         v$session ss
where va.sid =

 ss.sid and 
 va.object in ('OBJ1','OB2','OBJ3') 
  and  SS.STATUS='ACTIVE';

Objeto Ocupado

select 
   o.object_name,
   l.type type_lock,
   l.request,
   s.process,
   s.username
 from
   v$lock l,

   dba_objects o,

   v$session s
where o.object_name in 
   ('obj1', 'obj2', 'obj3', 'obj4')
    and o.owner='owner'
    and s.sid =l.sid
    and l.type in ('TM','TX');

Bloqueo de una tabla

bottom of page