Archive for November, 2012

Matar sesiones de Oracle que bloquean la compilación de un paquete

Thursday, November 1, 2012 21:15 2 Comments

SELECT ‘ALTER SYSTEM KILL SESSION ‘||””||sid||’,’||serial||”’;’ FROM ( SELECT sid, serial# AS SERIAL FROM v$session WHERE sid IN (SELECT SID FROM v$access WHERE object = ‘XX_PACKAGE_NAME_XX’) )select ‘ALTER SYSTEM KILL SESSION ‘||””||sid||’,’||serial||”’;’ from ( select sid, serial# AS SERIAL from v$session where sid IN (select SID from v$access where object = ‘XX_PACKAGE_NAME_XX’) )

This was posted under category: Administrador Sistemas, Oracle