GV$RULE_SET
select inst_id, -- INST_ID NUMBER kglnaown, -- OWNER VARCHAR2(64) kglnaobj, -- NAME VARCHAR2(1000) kglobt08, -- CPU_TIME NUMBER kglobt09, -- ELAPSED_TIME NUMBER kglnatim, -- FIRST_LOAD_TIME DATE kglobtt0, -- LAST_LOAD_TIME DATE kglobt10, -- LAST_LOADING_TIME NUMBER kglobhs0+kglobhs6, -- SHARABLE_MEM NUMBER kglhdldc, -- RELOADS NUMBER kglhdivc, -- INVALIDATIONS NUMBER kglobt11, -- EVALUATIONS NUMBER kglobt12, -- FIRST_HIT_EVALUATIONS NUMBER kglobt13, -- SIMPLE_RULES_ONLY_EVALUATIONS NUMBER kglobt14, -- SQL_FREE_EVALUATIONS NUMBER kglobt15, -- SQL_EXECUTIONS NUMBER kglobt16, -- CONDITIONS_PROCESSED NUMBER kglobt17, -- TRUE_RULES NUMBER kglobt18, -- MAYBE_RULES NUMBER kglobt19, -- VARIABLE_VALUE_FUNCTION_CALLS NUMBER kglobt20, -- VARIABLE_METHOD_FUNCTION_CALLS NUMBER kglobt21 -- EVALUATION_FUNCTION_CALLS NUMBER from x$kglob where (kglhdnsp = 23) and (kglobtyp = 46)

home |  up  |  mailbox