Gather_index_stats
is a procedure to gather all the index statistics for the user
specified schema. Certain types of indexes cannot be analyzed in
parallel such as cluster indexes, domain indexes and bitmap join
indexes.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
INDNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
NULL
|
|
ESTIMATE_PERCENT
|
NUMBER
|
IN
|
ESTIMATE_PERCENT
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
DEGREE
|
NUMBER
|
IN
|
DEGREE
|
|
GRANULARITY
|
VARCHAR2
|
IN
|
GRANULARITY
|
|
NO_INVALIDATE
|
BOOLEAN
|
IN
|
NO_INVALIDATE
|
|
FORCE
|
BOOLEAN
|
IN
|
FALSE
|
Table 7.105:
Gather_index_stats Parameters
Gather_schema_stats
is an overloaded procedure to gather statistics for all of the
database objects for the user specified schema.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
ESTIMATE_PERCENT
|
NUMBER
|
IN
|
ESTIMATE_PERCENT
|
|
BLOCK_SAMPLE
|
BOOLEAN
|
IN
|
FALSE
|
|
METHOD_OPT
|
VARCHAR2
|
IN
|
METHOD_OPT
|
|
DEGREE
|
NUMBER
|
IN
|
DEGREE
|
|
GRANULARITY
|
VARCHAR2
|
IN
|
GRANULARITY
|
|
CASCADE
|
BOOLEAN
|
IN
|
CASCADE
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
OTPIONS
|
VARCHAR2
|
IN
|
GATHER
|
|
{ OBJLIST }
|
OBJECTTAB
|
OUT
|
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
|
NO_INVALIDATE
|
BOOLEAN
|
IN
|
NO_INVALIDATE
|
|
FORCE
|
BOOLEAN
|
IN
|
FALSE
|
|
OBJ_FILTER_LIST
|
OBJECTTAB
|
IN
|
NULL
|
Table 7.106:
Gather_scheuma_stats Parameters
Gather_system_stats
is a procedure that gathers system statistics. The interval is
expressed in minutes. The gather mode must be one of the following:
NOWORKLOAD, INTERVAL, START or STOP.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
GATHER_MODE
|
VARCHAR2
|
IN
|
NOWORKLOAD
|
|
INTERVAL
|
INTEGER
|
IN
|
NULL
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
Table 7.107:
Gather_system_stats Parameters
Gather_table_stats
is a procedure to gather the table and index statistics for the user
specified table. Certain types of indexes cannot be analyzed in
parallel such as cluster indexes, domain indexes and bitmap join
indexes. However, table level statistics gathering will make heavy use
of the parallel degree.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
NULL
|
|
ESTIMATE_PERCENT
|
NUMBER
|
IN
|
ESTIMATE_PERCENT
|
|
BLCOK_SAMPLE
|
BOOELAN
|
IN
|
FALSE
|
|
METHOD_OPT
|
VARCHAR2
|
IN
|
METHOD_OPT
|
|
DEGREE
|
NUMBER
|
IN
|
DEGREE
|
|
GRANULARITY
|
VARCHAR2
|
IN
|
GRANULARITY
|
|
CASCADE
|
BOOLEAN
|
IN
|
CASCADE
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
|
NO_INVALIDATE
|
BOOLEAN
|
IN
|
NO_INVALIDATE
|
|
FORCE
|
BOOLEAN
|
IN
|
FALSE
|
Table 7.108:
Gather_table_stats Parameters
Generate_stats
is a procedure to create object statistics from prior statistics
collections of related objects, mainly b-tree and bitmap indexes, of
the specified object and schema.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
OBJNAME
|
VARCHAR2
|
IN
|
|
|
ORGANIZED
|
VARCHAR2
|
IN
|
7
|
|
FORCE
|
VARCHAR2
|
IN
|
FALSE
|
Table 7.109:
Generate_stats Parameters
Get_column_stats
is an overloaded procedure that retrieves all the column level
information for both normal and user defined statistics. The normal
call to
get_column_stats is as follows:
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
COLNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
NULL
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
DISTINCT
|
NUMBER
|
OUT
|
|
|
DENSITY
|
NUMBER
|
OUT
|
|
|
NULLCNT
|
NUMBER
|
OUT
|
|
|
SREC
|
StatRec
|
OUT
|
|
|
AVGLEN
|
NUMBER
|
OUT
|
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
Table 7.110:
Get_column_stats Parameters, Normal Call
The user defined statistics call to
get_column_stats is as follows:
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
COLNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
NULL
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
EXT_STATS
|
RAW
|
OUT
|
|
|
STATTYPOWN
|
VARCHAR2
|
OUT
|
NULL
|
|
STATTYPNAME
|
VARCHAR2
|
OUT
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
Table 7.111:
Get_column_stats Parameter, User Defined Statistics Call
and include the URL for the page.
