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 |