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