DBA_TUNE_MVIEW

DBA_TUNE_MVIEW displays the result of executing the DBMS_ADVISOR.TUNE_MVIEW procedure.

Related View

USER_TUNE_MVIEW displays the result of executing the DBMS_ADVISOR.TUNE_MVIEW procedure. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the task
TASK_NAME VARCHAR2(30)   Name of the task
ACTION_ID NUMBER NOT NULL Identifier of the action
SCRIPT_TYPE VARCHAR2(14)   Type of the script:

  • IMPLEMENTATION

  • UNDO
STATEMENT CLOB   Action statement

See Also:

"USER_TUNE_MVIEW"