ANALYZE_PART_OBJECT procedure - Gather statistics on a partitioned table or partitioned index

The ANALYZE_PART_OBJECT procedure provides the capability to gather statistics on a partitioned table or index.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_UTILITY.ANALYZE_PART_OBJECT (schema,object_name ,object_type,command_type,command_opt,sample_clause)

Parameters

schema
An input argument of type VARCHAR(128) that specifies the schema name of the schema whose objects are to be analyzed.
object_name
An input argument of type VARCHAR(128) that specifies the name of the partitioned object to be analyzed.
object_type
An optional input argument of type CHAR that specifies the type of object to be analyzed. Valid values are:
  • T - table;
  • I - index.
The default is T.
command_type
An optional input argument of type CHAR that specifies the type of analyze functionality to perform. Valid values are:
  • E - gather estimated statistics based upon on a specified number of rows or a percentage of rows in the sample_clause clause;
  • C - compute exact statistics; or
  • V - validate the structure and integrity of the partitions.
The default value is E.
command_opt
An optional input argument of type VARCHAR(1024) that specifies the options for the statistics calculation. For command_type E or C, this argument can be any combination of:
  • [ FOR TABLE ]
  • [ FOR ALL COLUMNS ]
  • [ FOR ALL LOCAL INDEXES ]
For command_type V, this argument can be CASCADE if object_type is T. The default value is NULL.
sample_clause
An optional input argument of type VARCHAR(128). If command_type is E, this argument contains the following clause to specify the number of rows or percentage of rows on which to base the estimate.
SAMPLE n { ROWS | PERCENT }
The default value is SAMPLE 5 PERCENT.

Authorization

EXECUTE privilege on the DBMS_UTILITY module.