15.147 SEM_APIS.SET_MODEL_STATS

Format

SEM_APIS.SET_MODEL_STATS (
     model_name     IN VARCHAR2, 
     numrows        IN NUMBER DEFAULT NULL, 
     numblks        IN NUMBER DEFAULT NULL, 
     avgrlen        IN NUMBER DEFAULT NULL, 
     flags          IN NUMBER DEFAULT NULL, 
     no_invalidate  IN BOOLEAN DEFAULT DBMS_STATS.AUTO_INVALIDATE, 
     cachedblk      IN NUMBER DEFAULT NULL, 
     cachehit       IN NUMBER DEFAULT NULL, 
     force          IN BOOLEAN DEFAULT FALSE,
     network_owner  IN VARCHAR2 DEFAULT NULL,
     network_name   IN VARCHAR2 DEFAULT NULL);

Description

Sets statistics for a specified model.

Parameters

model_name

Name of the model.

(other parameters)

See the parameter explanations for the DBMS_STATS.DELETE_TABLE_STATS procedure in Oracle Database PL/SQL Packages and Types Reference, although force here applies to model statistics.

network_owner

Owner of the semantic network. (See Table 1-2.)

network_name

Name of the semantic network. (See Table 1-2.)

Usage Notes

See the information about the DBMS_STATS package inOracle Database PL/SQL Packages and Types Reference.

See also Managing Statistics for Semantic Models and the Semantic Network.

For information about semantic network types and options, see RDF Networks.

Examples

The following example sets statistics for a model named FAMILY.

EXECUTE SEM_APIS.SET_MODEL_STATS('family', numrows => 100);