Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_ADVISOR_DEFINITIONS

DBA_ADVISOR_DEFINITIONS displays the properties of all advisors in the database. The view contains one row for each task, representing the current state of the task as well as execution-specific data such as progress monitoring and completion status.

Column Datatype NULL Description
ADVISOR_ID NUMBER NOT NULL Unique identifier for the advisor
ADVISOR_NAME VARCHAR2(30) NOT NULL Name of the advisor
PROPERTY NUMBER NOT NULL Properties:
  • Bit 0: - Indicates whether the advisor runs in COMPREHENSIVE mode (1) or not (0)

  • Bit 1: - Indicates whether the advisor runs in LIMITED mode (1) or not (0)

  • Bit 2: - Indicates whether the advisor is resumable (1) or not (0)

  • Bit 3: - Indicates whether the advisor accepts user directives (1) or not (0)