TUNE_MVIEW generates
two sets of output results, one for the creation of new materialized views and the other for the
removal of previously created materialized views. The end result should be a set of materialized
views that can be fast refreshed, replacing materialized views that cannot be fast refreshed.
620 Oracle Database 11g DBA Handbook
You can view the TUNE_MVIEW output via the USER_TUNE_MVIEW data dictionary view, or
you can generate its scripts via the GET_TASK_SCRIPT and CREATE_FILE procedures shown in the
previous listings.
The supplied programs for the DBMS_ADVISOR package are shown in Table 17-2.
Subprocedure Description
ADD_SQLWKLD_REF Add a workload reference to an Advisor task.
ADD_SQLWKLD_STATEMENT Add a single statement to a workload.
CANCEL_TASK Cancel a currently executing task operation.
CREATE_FILE Create an external file from a PL/SQL CLOB
variable.
CREATE_OBJECT Create a new task object.
CREATE_SQLWKLD Create a new workload object.
CREATE_TASK Create a new Advisor task in the repository.
DELETE_SQLWKLD Delete an entire workload object.
DELETE_SQLWKLD_REF Delete an entire workload object.
DELETE_SQLWKLD_STATEMENT Delete one or more statements from a workload.
DELETE_TASK Delete the specified task from the repository.
EXECUTE_TASK Execute the specified task.
GET_REC_ATTRIBUTES Retrieve specific recommendation attributes
from a task.
GET_TASK_SCRIPT Create and return an executable SQL script of the
Advisor recommendations.
Pages:
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913