[Home] [Help] [Dependency Information]
Object Name: | GV_$RULE_SET |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
OWNER | VARCHAR2 | (30) | ||
NAME | VARCHAR2 | (30) | ||
CPU_TIME | NUMBER | |||
ELAPSED_TIME | NUMBER | |||
FIRST_LOAD_TIME | DATE | |||
LAST_LOAD_TIME | DATE | |||
LAST_LOADING_TIME | NUMBER | |||
SHARABLE_MEM | NUMBER | |||
RELOADS | NUMBER | |||
INVALIDATIONS | NUMBER | |||
EVALUATIONS | NUMBER | |||
FIRST_HIT_EVALUATIONS | NUMBER | |||
SIMPLE_RULES_ONLY_EVALUATIONS | NUMBER | |||
SQL_FREE_EVALUATIONS | NUMBER | |||
SQL_EXECUTIONS | NUMBER | |||
CONDITIONS_PROCESSED | NUMBER | |||
TRUE_RULES | NUMBER | |||
MAYBE_RULES | NUMBER | |||
VARIABLE_VALUE_FUNCTION_CALLS | NUMBER | |||
VARIABLE_METHOD_FUNCTION_CALLS | NUMBER | |||
EVALUATION_FUNCTION_CALLS | NUMBER | |||
RESULT_CACHE_HITS | NUMBER | |||
IS_RESULT_CACHE | VARCHAR2 | (3) | ||
RESULT_CACHE_ELEMENTS | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, OWNER
, NAME
, CPU_TIME
, ELAPSED_TIME
, FIRST_LOAD_TIME
, LAST_LOAD_TIME
, LAST_LOADING_TIME
, SHARABLE_MEM
, RELOADS
, INVALIDATIONS
, EVALUATIONS
, FIRST_HIT_EVALUATIONS
, SIMPLE_RULES_ONLY_EVALUATIONS
, SQL_FREE_EVALUATIONS
, SQL_EXECUTIONS
, CONDITIONS_PROCESSED
, TRUE_RULES
, MAYBE_RULES
, VARIABLE_VALUE_FUNCTION_CALLS
, VARIABLE_METHOD_FUNCTION_CALLS
, EVALUATION_FUNCTION_CALLS
, RESULT_CACHE_HITS
, IS_RESULT_CACHE
, RESULT_CACHE_ELEMENTS
, CON_ID
FROM SYS.GV_$RULE_SET;
|
|
|