DBA_ADVISOR_COMMANDS

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