16.3 SEM_PERF.DROP_EXTENDED_STATS

Format

SEM_PERF.DROP_EXTENDED_STATS (
     network_owner IN VARCHAR2 DEFAULT NULL,
     network_name  IN VARCHAR2 DEFAULT NULL);

Description

Drops column groups used for extended optimizer statistics on the RDF_LINK$ table.

Parameters

network_owner

Owner of the semantic network. (See Table 1-2.)

network_name

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

Usage Notes

To use this procedure, you must connect as a user with permission to execute it. Network owners and DBAs have privileges to execute this procedure.

The default column groups that will be dropped from RDF_LINK$ are: (CANON_END_NODE_ID, START_NODE_ID) (P_VALUE_ID, CANON_END_NODE_ID) (P_VALUE_ID, START_NODE_ID)

See also:

• Dropping Extended Statistics at the Network Level

• The information about the DBMS_STATS package in Oracle Database PL/SQL Packages and Types Reference

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

Examples

The following example drops extended statistics for the semantic network named NET1 owned by RDFUSER:

EXECUTE SEM_PERF.DROP_EXTENDED_STATS(network_owner=>'RDFUSER', network_name=>'NET1');