Oracle EXPORT_FIXED_OBJECT_STATS

Oracle Database Tips by Donald Burleson

Advanced Oracle Utilities: The Definitive Reference by Rampant TechPress is written by top Oracle database experts (Bert Scalzo, Donald Burleson, and Steve Callan). The following is an excerpt from the book.

Export_fixed_object_stats is a procedure that copies the statistics of the SGA memory's fixed tables - the X$ tables - Export_fixed_object_stats into the user specified statistics table.

Argument	Type	In / Out	Default Value
STATTAB	VARCHAR2	IN
STATID	VARCHAR2	IN	NULL
STATOWN	VARCHAR2	IN	NULL

Table 7.94: Export_fixed_object_stats Parameters

Export_index_stats is a procedure that copies the statistics of the specified index into the user specified statistics table.

Argument	Type	In / Out	Default Value
OWNNAME	VARCHAR2	IN
INDNAME	VARCHAR2	IN
PARTNAME	VARCHAR2	IN	NULL
STATTAB	VARCHAR2	IN
STATID	VARCHAR2	IN	NULL
STATOWN	VARCHAR2	IN	NULL

Table 7.95: Export_index_stats Parameters

Export_pending_stats is a procedure that copies the pending statistics of the specified table into the user specified statistics table.

Argument	Type	In / Out	Default Value
OWNNAME	VARCHAR2	IN	USER
TABNAME	VARCHAR2	IN
STATTAB	VARCHAR2	IN
STATID	VARCHAR2	IN	NULL
STATOWN	VARCHAR2	IN	USER

Table 7.96: Export_pending_stats Parameters

Export_schema_prefs is a procedure that copies all the statistics preferences of the specified schema into the user specified statistics table.

Argument	Type	In / Out	Default Value
OWNNAME	VARCHAR2	IN
STATTAB	VARCHAR2	IN
STATID	VARCHAR2	IN	NULL
STATOWN	VARCHAR2	IN	NULL

Table 7.97: Export_schema_prefs Parameters

Export_schema_stats is a procedure that copies all the statistics for all of the objects of the specified schema into the user specified statistics table.

Argument	Type	In / Out	Default Value
OWNNAME	VARCHAR2	IN
STATTAB	VARCHAR2	IN
STATID	VARCHAR2	IN	NULL
STATOWN	VARCHAR2	IN	NULL

Table 7.98: Export_schema_stats Parameters

Export_system_stats is a procedure that copies all the system statistics into the user specified statistics table.

Argument	Type	In / Out	Default Value
STATTAB	VARCHAR2	IN
STATID	VARCHAR2	IN	NULL
STATOWN	VARCHAR2	IN	NULL

Table 7.99: Export_system_stats Parameters

Export_table_prefs is a procedure that copies all the statistics preferences of the specified table into the user specified statistics table.

Argument	Type	In / Out	Default Value
OWNNAME	VARCHAR2	IN
TABNAME	VARCHAR2	IN
STATTAB	VARCHAR2	IN
STATID	VARCHAR2	IN	NULL
STATOWN	VARCHAR2	IN	NULL

Table 7.100: Export_table_prefs Parameters

Export_table_stats is a procedure that copies all the statistics of the specified table into the user specified statistics table.

Argument	Type	In / Out	Default Value
OWNNAME	VARCHAR2	IN
TABNAME	VARCHAR2	IN
PARTNAME	VARCHAR2	IN	NULL
STATTAB	VARCHAR2	IN
STATID	VARCHAR2	IN	NULL
CASCADE	VARCHAR2	IN	TRUE
STATOWN	VARCHAR2	IN	NULL

Table 7.101: Export_table_stats Parameters

Flush_database_monitoring_info is a procedure that flushes all the in-memory monitoring information currently in the dictionary. It has no parameters.

Gather_database_stats is an overloaded procedure to gather statistics for all of the database objects.

Argument	Type	In / Out	Default Value
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
GATHER_SYS	BOOLEAN	IN	TRUE
NO_INVALIDATE	BOOLEAN	IN	NO_INVALIDATE
OBJ_FILTER_LIST	OBJECTTAB	IN	NULL

Table 7.102: Gather_database_stats Parameters

Gather_dictionary_stats is an overloaded procedure to gather statistics for all of the database objects for dictionary schemas such as SYS, SYSTEM and other RDBMS components.

Argument	Type	In / Out	Default Value
COMP_ID	VARCHAR2	IN	NULL
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
OBJ_FILTER_LIST	OBJECTTAB	IN	NULL