Archive for November, 2012

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

Thursday, November 1, 2012 21:15 1 Comment

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