16.4 SEM_PERF.EXPORT_NETWORK_STATS

Format

SEM_PERF.EXPORT_NETWORK_STATS (
     stattab        IN VARCHAR2, 
     statid         IN VARCHAR2 DEFAULT NULL, 
     cascade        IN BOOLEAN DEFAULT TRUE, 
     statown        IN VARCHAR2 DEFAULT NULL, 
     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

Exports the statistics for the semantic network and stores them in the user statistics table.

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.EXPORT_TABLE_STATS procedure in Oracle Database PL/SQL Packages and Types Reference.

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 exports the statistics for the semantic network and stores them in a table named STAT_TABLE.

EXECUTE SEM_APIS.EXPORT_NETWORK_STATS('stat_table', network_owner=>'RDFUSER', network_name=>'NET1');