15.51 SEM_APIS.DELETE_MODEL_STATS

Format

SEM_APIS.DELETE_MODEL_STATS (
     model_name       IN VARCHAR2, 
     cascade_parts    IN BOOLEAN DEFAULT TRUE, 
     cascade_columns  IN BOOLEAN DEFAULT TRUE, 
     cascade_indexes  IN BOOLEAN DEFAULT TRUE, 
     no_invalidate    IN BOOLEAN DEFAULT DBMS_STATS.AUTO_INVALIDATE, 
     force            IN BOOLEAN DEFAULT FALSE,
     network_owner    IN VARCHAR2 DEFAULT NULL,
     network_name     IN VARCHAR2 DEFAULT NULL);

Description

Deletes 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 RDF network. (See Table 1-2.)

network_name

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

Usage Notes

Only the model owner or a users with DBA privileges can execute this procedure.

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 RDF network.

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

Examples

The following example deletes statistics for a model named FAMILY.

EXECUTE SEM_APIS.DELETE_MODEL_STATS('family');