Set_index_stats
is an overloaded procedure that sets all the index level information
for both normal and user defined statistics. The normal call to
set_index_stats is as follows:
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
INDNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
NULL
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
NUMROWS
|
NUMBER
|
IN
|
NULL
|
|
NUMLBLKS
|
NUMBER
|
IN
|
NULL
|
|
NUMDIST
|
NUMBER
|
IN
|
NULL
|
|
AVGLBLK
|
NUMBER
|
IN
|
NULL
|
|
AVGDBLK
|
NUMBER
|
IN
|
NULL
|
|
CLSTFCT
|
NUMBER
|
IN
|
NULL
|
|
INDLEVEL
|
NUMBER
|
IN
|
NULL
|
|
FLAGS
|
NUMBER
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
|
NO_INVALIDATE
|
BOOLEAN
|
IN
|
NO_INVALIDATE
|
|
GUESSQ
|
NUMBER
|
IN
|
NULL
|
|
CACHEDBLK
|
NUMBER
|
IN
|
NULL
|
|
CACHEHIT
|
NUMBER
|
IN
|
NULL
|
|
FORCE
|
BOOLEAN
|
IN
|
FALSE
|
Table 7.146:
Set_index_stats Parameters, Normal Call
The user defined statistics call to
set_index_stats is as follows:
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
INDNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
NULL
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
EXT_STATS
|
RAW
|
IN
|
|
|
STATTYPOWN
|
VARCHAR2
|
IN
|
NULL
|
|
STATTYPNAME
|
VARCHAR2
|
OUT
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
|
NO_INVALIDATE
|
BOOLEAN
|
IN
|
NO_INVALIDATE
|
|
CACHEDBLK
|
NUMBER
|
IN
|
NULL
|
|
CACHEHIT
|
NUMBER
|
IN
|
NULL
|
|
FORCE
|
BOOLEAN
|
IN
|
FALSE
|
Table 7.147:
Set_index_stats Parameters, User Defined Statistics Call
Set_schema_prefs
is a procedure that sets all the statistics preferences for the
specified schema. The valid values for the
pname parameter are CASCADE, DEGREE, ESTIMATE_PERCENT,
METHOD_OPT, NO_INVALIDATE, GRANULARITY, PUBLISH, INCREMENTAL and
STALE_PERCENT.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
PNAME
|
VARCHAR2
|
IN
|
|
|
PVALUE
|
VARCHAR2
|
IN
|
|
Table 7.148:
Set_schema_prefs Parameters
Set_system_stats
is a procedure that sets all the system statistics from the user
specified statistics table to the data dictionary. The legal values
for
pname include iotfrspeed, ioseektim, sreadtim, mreadtim,
cpuspeed, cpuspeednw, mbrc, maxthr and slavthr.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
PNAME
|
VARCHAR2
|
IN
|
|
|
PVALUE
|
VARCHAR2
|
IN
|
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
Table 7.149:
Set_table_prefs Parameters
Set_table_prefs
is a procedure that sets all the statistics preferences of the
specified table from the user specified statistics table into the data
dictionary. The valid values for the
pname parameter are CASCADE, DEGREE, ESTIMATE_PERCENT,
METHOD_OPT, NO_INVALIDATE, GRANULARITY, PUBLISH, INCREMENTAL and
STALE_PERCENT.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
PNAME
|
VARCHAR2
|
IN
|
|
|
PVALUE
|
VARCHAR2
|
IN
|
|
|
STATTAB
|
VARCHAR2
|
IN
|
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
Table 7.150:
Set_table_prefs Parameters
Set_table_stats
is a procedure that sets all the statistics of the specified table
from the user specified statistics table to the data dictionary.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
NULL
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
NUMROWS
|
NUMBER
|
IN
|
NULL
|
|
NUMBLKS
|
NUMBER
|
IN
|
NULL
|
|
AVGRLEN
|
NUMBER
|
IN
|
NULL
|
|
FLAGS
|
NUMBER
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
|
NO_INVALIDATE
|
BOOLEAN
|
IN
|
NO_INVALIDATE
|
|
CACHEDBLK
|
NUMBER
|
IN
|
NULL
|
|
CACHEDHIT
|
NUMBER
|
IN
|
NULL
|
|
FORCE
|
BOOLEAN
|
IN
|
FALSE
|
Table 7.151:
Set_table_stats Parameters
Show_extended_stats_name
is a function to display the statistics entry names for user specified
extensions. It returns that name as a VARCHAR2.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNANME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
EXTENSION
|
VARCHAR2
|
IN
|
|
Table 7.152:
Show_extended_stats_name Parameters
Unlock_partition_stats
is a procedure to unlock the table statistics for the user specified
partition.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
|
Table 7.153:
Unlock_partition_stats Parameters
Unlock_schema_stats
is a procedure to unlock all the table statistics for the user
specified schema.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
Table 7.154:
Unlock_schema_stats Parameter
Unlock_table_stats
is a procedure to unlock the table statistics for the user specified
table.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
Table 7.155:
Unlock_table_stats Parameters
Upgrade_stat_table
is a procedure to upgrade an older version statistics table to the
current definition.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
STATTAB
|
VARCHAR2
|
IN
|
|
Table 7.156:
Upgrade_stat_table Parameters
and include the URL for the page.
