1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
  4. DBA_ADVISOR_COMMANDS

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