IMPORT_SQLWKLD_SCHEMA Import data into a workload from the current
SQL cache.
IMPORT_SQLWKLD_SQLCACHE Import data into a workload from the current
SQL cache.
IMPORT_SQLWKLD_STS Import data into a workload from a SQL Tuning Set.
IMPORT_SQLWKLD_SUMADV Import data into a workload from the current
SQL cache.
IMPORT_SQLWKLD_USER Import data into a workload from the current
SQL cache.
INTERRUPT_TASK Stop a currently executing task, ending its
operations as it would at a normal exit.
MARK_RECOMMENDATION Set the annotation status for a particular
recommendation.
QUICK_TUNE Perform an analysis on a single SQL statement.
TABLE 17-2 DBMS_ADVISOR Subprograms
Chapter 17: Managing Distributed Databases 621
An additional package, DBMS_DIMENSION, provides these two procedures:
DESCRIBE_DIMENSION Show the definition of the input dimension, including owner,
name, levels, hierarchies, and attributes.
VALIDATE DIMENSION Verify that the relationships specified in a dimension are correct.
You can use the DBMS_DIMENSION package to validate and display the structure of your
dimensions.
Enforcing Referential Integrity Among Materialized Views
The referential integrity between two related tables, both of which have simple materialized views
based on them, may not be enforced in their materialized views. If the tables are refreshed at
different times, or if transactions are occurring on the master tables during the refresh, it is possible
for the materialized views of those tables to not reflect the referential integrity of the master tables.
Pages:
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914