4.11 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