DBA_ADVISOR_DEFINITIONS

Oracle 11gR1

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)

Note:

1.

select * from DBA_ADVISOR_DEFINITIONS;

ADVISOR_ID	ADVISOR_NAME	PROPERTY
1	ADDM	1: 00000001
2	SQL Access Advisor	15: 00001111
3	Undo Advisor	1: 00000001
4	SQL Tuning Advisor	7: 00000111
5	Segment Advisor	3: 00000011
6	SQL Workload Manager	0: 00000000
7	Tune MView	31:00011111

Oracle data dictionary views