Online Documentation for SQL Manager for Oracle

Specifying additional settings


Use this step of the wizard to specify additional settings for the specified statistics operation. The set of of options depend on the objects for statistics, selected at the first step.

 

Advanced Statistics Wizard - Specifying additional settings - Schema

 

Target schema

Use the drop-down list to select the schema containing the stat table.

 

Target name

Use the drop-down list to select the stat table (stattab) identifier describing where the current statistics will be saved, or enter a name (the stat table that will be created in this case).

 

Stat ID

Specify identifier (optional) to associate with these statistics within stat table (stattab).

 

Mode

Use the drop-down list to specify further specification of which objects to gather statistics for:

NOWORKLOAD (in this mode characteristics of the I/O system are captured; gathering may take a few minutes and depends on the size of the database; during this period Oracle will estimate the average read seek time and transfer speed for the I/O system)

INTERVAL (in this mode system activity is captured during a specified interval)

START | STOP (system activity is captured during specified start and stop times, and the dictionary or stat table is refreshed with statistics for the elapsed period)

 

Interval

Specify time, in minutes, to gather statistics. This value is applied only when INTERVAL mode is selected.

 

Partition name

Specify the name of the partition on which you want statistics to be gathered.

 

Granularity

Use the drop-down list to specify granularity of statistics to collect:

ALL (gathers all, i.e. subpartition, partition, and global, statistics)

AUTO (determines the granularity based on the partitioning type)

DEFAULT (gathers global- and partition-level statistics)

GLOBAL (gathers global statistics)

GLOBAL AND PARTITION (gathers the global and partition level statistics; no subpartition level statistics are gathered even if it is a composite partitioned object)

PARTITION (gathers partition-level statistics)

SUBPARTITION (gathers subpartition-level statistics)

 

Options

Use the drop-down list to specify further specification of which objects to gather statistics for:

GATHER (gathers statistics on all objects in the schema)

GATHER AUTO (gathers all necessary statistics automatically; Oracle implicitly determines which objects need new statistics, and determines how to gather those statistics)

GATHER STALE (gathers statistics on stale objects as determined by looking at the *_tab_modifications views; also returns a list of stale objects)

GATHER EMPTY (gathers statistics on objects which currently have no statistics; also returns a list of objects which currently have no statistics)

LIST AUTO (returns a list of objects to be processed with GATHER AUTO)

LIST STALE (returns list of stale objects as determined by looking at the *_tab_modifications views)

LIST EMPTY (returns list of objects which currently have no statistics)

 

Method opt

Use the drop-down list to specify the method of gathering stats: FOR ALL INDEXES COLUMNS, FOR ALL HIDDEN COLUMNS.

 

Degree

Specify degree of parallelism (1 - serial execution).

 

Estimate percent

Specify the percentage of rows to estimate.

 

CheckBox No invalidate

If this option is selected, the dependent cursors are not invalidated.

 

CheckBox Block sample

This option specifies whether or not to use random block sampling instead of random row sampling. Random block sampling is more efficient, but if the data is not randomly distributed on disk, then the sample values may be somewhat correlated.

 

CheckBox Force

If this option is selected, statistics of the schema are gathered even if the object is locked.

 

CheckBox Gather sys

Select this option to gather statistics on the objects owned by the SYS user.

 

Click the Next button to proceed to the Managing statistics step of the wizard.