SYS.DBMS_FEATURE_REGISTER_ALLFEAT dependencies on DBA_ADVISOR_DEFINITIONS

Line 2099: * listed in DBA_ADVISOR_DEFINITIONS and DBA_ADVISOR_USAGE views.

2095:
2096:
2097: /***********************************************************************
2098: * All advisors using the advisor framework. This includes all advisors
2099: * listed in DBA_ADVISOR_DEFINITIONS and DBA_ADVISOR_USAGE views.
2100: ************************************************************************/
2101: /* FIXME: Mike would like to use a pl/sql procedure instead of a query */
2102: declare
2103: dbu_detect_sql VARCHAR2(32767);

Line 2106: FROM dba_advisor_definitions

2102: declare
2103: dbu_detect_sql VARCHAR2(32767);
2104: begin
2105: FOR adv_rec IN (SELECT advisor_name, advisor_id
2106: FROM dba_advisor_definitions
2107: WHERE bitand(property, 64) != 64
2108: ORDER BY advisor_id)
2109: LOOP
2110: -- build the query that will be executed to track an advisor usage