../E40402-16.epub /> ../E40402-16.mobi />

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