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');