DBA_ADVISOR_COMMANDS

Oracle 11gR1

DBA_ADVISOR_COMMANDS displays information about the commands used by all advisors in the database for specifying recommendation actions. In addition to the set of commands in the COMMAND column of V$SESSION, the following additional commands are defined:

· RUN ADVISOR

· CHECK EXECUTION PLAN

· ALTER PARAMETER

· ENABLE TRACE

Column	Datatype	NULL	Description
COMMAND_ID	NUMBER		Identifier of the command
COMMAND_NAME	VARCHAR2(64)		Name of the command

Note:

1.

select * from DBA_ADVISOR_COMMANDS;

COMMAND_ID	COMMAND_NAME
0	UNDEFINED
1	RUN SQL TUNING ADVISOR
2	CREATE INDEX
3	CREATE MATERIALIZED VIEW
4	CREATE MATERIALIZED VIEW LOG
5	NEVER CREATE INDEX
6	NEVER CREATE MATERIALIZED VIEW
7	NEVER CREATE MATERIALIZED VIEW LOG
8	NEVER DROP INDEX
9	NEVER DROP MATERIALIZED VIEW
10	NEVER MODIFY INDEX
11	SET INDEX MAXIMUM COUNT
12	SET INDEX SCHEMA
13	SET INDEX TABLESPACE
14	SET MATERIALIZED VIEW SCHEMA
15	SET MATERIALIZED VIEW TABLESPACE
16	SET STORAGE SIZE
17	DROP INDEX
18	DROP MATERIALIZED VIEW
19	DROP MATERIALIZED VIEW LOG
20	RETAIN INDEX
21	RETAIN MATERIALIZED VIEW
22	RETAIN MATERIALIZED VIEW LOG
23	CREATE SUB MATERIALIZED VIEW
24	DROP SUB MATERIALIZED VIEW
25	CREATE REWRITE EQUIVALENCE
26	DROP REWRITE EQUIVALENCE
27	ALTER MATERIALIZED VIEW LOG
28	GATHER TABLE STATISTICS
29	GATHER INDEX STATISTICS
30	SET UNDO_RETENTION
31	SET UNDO TABLESPACE SIZE
32	ACCEPT SQL PROFILE
33	REWRITE QUERY
34	RUN SEGMENT ADVISOR
35	ALTER PARAMETER
36	SHRINK SPACE
37	REORG OBJECT

Oracle data dictionary views