16.1 SEM_PERF.ANALYZE_AUX_TABLES
Format
SEM_PERF.ANALYZE_AUX_TABLES( model_name IN VARCHAR2, estimate_percent IN NUMBER DEFAULT DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt IN VARCHAR2 DEFAULT NULL, degree IN NUMBER DEFAULT DBMS_STATS.AUTO_DEGREE, network_owner IN DBMS_ID DEFAULT NULL, network_name IN VARCHAR2 DEFAULT NULL);
Description
Analyzes all the SPM tables currently present for the given RDF model.
Parameters
- model_name
-
Name of the RDF model.
- estimate_percent
-
Determines the percentage of rows to sample. For more information on gathering the
estimate_percent
statistics, see DBMS_STATS.GATHER_TABLE_STATS procedure. - method_opt
-
Determines the column statistics collection. For more information on gathering the column statistics, see DBMS_STATS.GATHER_TABLE_STATS
- degree
-
Determines the degree of parallelism used for gathering statistics. For more information on this procedure parameter see DBMS_STATS.GATHER_TABLE_STATS
- network_owner
-
Owner of the semantic network. (See Table 1-2.)
- network_name
-
Name of the semantic network. (See Table 1-2.)
Usage Notes
Examples
The following example gathers statistics for SPM auxiliary tables.
EXECUTE SEM_PERF.ANALYZE_AUX_TABLES('m1',network_owner=>'RDFUSER',network_name=>'NET1');
Parent topic: SEM_PERF Package Subprograms