/*
 * overeno na 10gR2
 */  

SELECT S.SID, S.SERIAL#, S.OSUSER, ACTION,  V.*
  FROM KU$_SWITCH_COMPILER_VIEW V, V$session s
 WHERE s.PLSQL_ENTRY_OBJECT_ID = v.obj_num
   AND v.debug = 'TRUE'