DBA_ADDM_RULE_INFO

DBA_ADDM_RULE_INFO displays information about registered rules for all ADDM tasks in the database.

USER_ADDM_RULE_INFO displays information about registered rules for ADDM tasks owned by the current user.

Column Datatype NULL Description
RULE_NAME VARCHAR2(128) NOT NULL Unique rule identifier
PACKAGE_NAME VARCHAR2(128)   Name of the package containing the rule evaluation function
OWNER_NAME VARCHAR2(128)   Name of the schema that includes the package containing the rule evaluation function
PUBLISHER VARCHAR2(512)  

User-readable identifier of the owner

Note that PUBLISHER can be different from OWNER_NAME.
EVAL_FUNCTION VARCHAR2(128)   Name of the PL/SQL function that evaluates the rule logic
SPECIFICATION_JSON CLOB  

Text of the JSON rule specification

This column is applicable only for rules defined by JSON, not by an evaluation function.
DESCRIPTION VARCHAR2(512)   Readable explanation of what the rule evaluates and recommendations
APPLICABLE VARCHAR2(512)   Comma-separated list of applicability criteria specifying where the rule should be evaluated
PARENTS VARCHAR2(4000)   Comma-separated list of rule parents
ENABLED VARCHAR2(10)  

Attribute that controls the execution of the rule:

  • USER - The rule is enabled for tasks owned by the user who registered the rule. This is the default.
  • ALL - The rule is enabled for all users and all tasks in the container.
  • NONE - The rule is disabled.
REGISTERED_TIME_UTC DATE   Time at which the rule was registered, in UTC time zone
LAST_UPDATE_TIME_UTC DATE   Time at which the rule was updated, in UTC time zone

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.4.

See Also: “USER_ADDM_RULE_INFO”