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