16.6 SEM_PERF.IMPORT_NETWORK_STATS
Format
SEM_PERF.IMPORT_NETWORK_STATS ( stattab IN VARCHAR2, statid IN VARCHAR2 DEFAULT NULL, cascade IN BOOLEAN DEFAULT TRUE, statown IN VARCHAR2 DEFAULT NULL, no_invalidate IN BOOLEAN DEFAULT FALSE, force IN BOOLEAN DEFAULT FALSE, stat_category IN VARCHAR2 DEFAULT 'OBJECT_STATS', options IN VARCHAR2 DEFAULT NULL, network_owner IN VARCHAR2 DEFAULT NULL, network_name IN VARCHAR2 DEFAULT NULL);
Description
Retrieves the statistics for the semantic network from a user statistics table and stores them in the dictionary.
Parameters
- options
-
Controls the scope of the operation:
-
If
MDSYS.SDO_RDF.VALUE_TABLE_ONLY
, the operation applies only to the RDF_VALUE$ table. -
If
MDSYS.SDO_RDF.LINK_TABLE_ONLY
, the operation applies only to the RDF_LINK$ table. -
If null (the default), the operation applies to both the RDF_VALUE$ and RDF_LINK$ tables.
-
- (other parameters)
-
See the parameter explanations for the DBMS_STATS.IMPORT_TABLE_STATS procedure in Oracle Database PL/SQL Packages and Types Reference, although
force
here applies to network 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 imports the statistics for the semantic network in a table named STAT_TABLE
, and stores them in the dictionary.
EXECUTE SEM_APIS.IMPORT_NETWORK_STATS('stat_table', network_owner=>'RDFUSER', network_name=>'NET1');
Parent topic: SEM_PERF Package Subprograms