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');
Parent topic: SEM_APIS Package Subprograms