UPDATE_OBJECT Update a task object.
UPDATE_REC_ATTRIBUTES Update an existing recommendation for the
specified task.
UPDATE_SQLWKLD_ATTRIBUTES Update a workload object.
UPDATE_SQLWKLD_STATEMENT Update one or more SQL statements in a workload.
UPDATE_TASK_ATTRIBUTES Update a task??™s attributes.
TABLE 17-2 DBMS_ADVISOR Subprograms (continued)
622 Oracle Database 11g DBA Handbook
Using refresh groups provides another solution to the referential integrity problem. You can
collect related materialized views into refresh groups. The purpose of a refresh group is to coordinate
the refresh schedules of its members. Materialized views whose master tables have relationships
with other master tables are good candidates for membership in refresh groups. Coordinating the
refresh schedules of the materialized views will maintain the master tables??™ referential integrity in
the materialized views as well. If refresh groups are not used, the data in the materialized views
may be inconsistent with regard to the master tables??™ referential integrity.
Manipulation of refresh groups is performed via the DBMS_REFRESH package. The procedures
within that package are MAKE, ADD, SUBTRACT, CHANGE, DESTROY, and REFRESH, as shown
in the following examples. Information about existing refresh groups can be queried from the
USER_REFRESH and USER_REFRESH_CHILDREN data dictionary views.
NOTE
Materialized views that belong to a refresh group do not have to
belong to the same schema, but they do have to be all stored within
the same database.
Pages:
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916