Keyword: STATISTIC

Tables

Table Name	Description
ALL_PART_COL_STATISTICS
ALL_REPRESOLUTION_STATISTICS	Statistics for conflict resolutions for replicated tables which are accessible to the user
ALL_REPRESOL_STATS_CONTROL	Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user
ALL_SUBPART_COL_STATISTICS
ALL_TAB_COL_STATISTICS	Columns of user's tables, views and clusters
DBA_PART_COL_STATISTICS
DBA_REPRESOLUTION_STATISTICS	Statistics for conflict resolutions for all replicated tables in the database
DBA_REPRESOL_STATS_CONTROL	Information about statistics collection for conflict resolutions for all replicated tables in the database
DBA_SUBPART_COL_STATISTICS
DBA_TAB_COL_STATISTICS	Columns of user's tables, views and clusters
GV$BUFFER_POOL_STATISTICS	Synonym for GV_$BUFFER_POOL_STATISTICS
GV$LOGMNR_STATS	Synonym for GV_$LOGMNR_STATS
GV$LOGSTDBY_STATS	Synonym for GV_$LOGSTDBY_STATS
GV$SEGMENT_STATISTICS	Synonym for GV_$SEGMENT_STATISTICS
GV$SQL_PLAN_STATISTICS	Synonym for GV_$SQL_PLAN_STATISTICS
GV$SQL_PLAN_STATISTICS_ALL	Synonym for GV_$SQL_PLAN_STATISTICS_ALL
GV$STATISTICS_LEVEL	Synonym for GV_$STATISTICS_LEVEL
INDEX_STATS	statistics on the b-tree
USER_PART_COL_STATISTICS
USER_REPRESOLUTION_STATISTICS	Statistics for conflict resolutions for user's replicated tables
USER_REPRESOL_STATS_CONTROL	Information about statistics collection for conflict resolutions for user's replicated tables
USER_SUBPART_COL_STATISTICS
USER_TAB_COL_STATISTICS	Columns of user's tables, views and clusters
V$BUFFER_POOL_STATISTICS	Synonym for V_$BUFFER_POOL_STATISTICS
V$LOGMNR_STATS	Synonym for V_$LOGMNR_STATS
V$LOGSTDBY_STATS	Synonym for V_$LOGSTDBY_STATS
V$SEGMENT_STATISTICS	Synonym for V_$SEGMENT_STATISTICS
V$SQL_PLAN_STATISTICS	Synonym for V_$SQL_PLAN_STATISTICS
V$SQL_PLAN_STATISTICS_ALL	Synonym for V_$SQL_PLAN_STATISTICS_ALL
V$STATISTICS_LEVEL	Synonym for V_$STATISTICS_LEVEL

top back to index

Columns

Column Name	Description
GLOBAL_STATS (DBA_IND_SUBPARTITIONS)
GLOBAL_STATS (USER_TAB_COL_STATISTICS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (USER_TAB_COLS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (USER_TAB_COLUMNS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (USER_SUBPART_COL_STATISTICS)
GLOBAL_STATS (ALL_TAB_COL_STATISTICS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (ALL_OBJECT_TABLES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (ALL_TAB_SUBPARTITIONS)
GLOBAL_STATS (DBA_ALL_TABLES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (COLS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (ALL_TAB_COLS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (USER_TAB_SUBPARTITIONS)
GLOBAL_STATS (ALL_TABLES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (USER_INDEXES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (DBA_INDEXES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (USER_IND_PARTITIONS)
GLOBAL_STATS (DBA_TAB_PARTITIONS)
GLOBAL_STATS (USER_IND_SUBPARTITIONS)
GLOBAL_STATS (TABS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (ALL_PART_COL_STATISTICS)
GLOBAL_STATS (ALL_INDEXES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (DBA_SUBPART_COL_STATISTICS)
GLOBAL_STATS (DBA_OBJECT_TABLES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (ALL_IND_SUBPARTITIONS)
GLOBAL_STATS (ALL_TAB_COLUMNS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (USER_TAB_PARTITIONS)
GLOBAL_STATS (DBA_TAB_COL_STATISTICS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (DBA_PART_COL_STATISTICS)
GLOBAL_STATS (ALL_SUBPART_COL_STATISTICS)
GLOBAL_STATS (DBA_TAB_COLS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (IND)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (USER_ALL_TABLES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (ALL_IND_PARTITIONS)
GLOBAL_STATS (USER_OBJECT_TABLES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (DBA_TAB_COLUMNS)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (DBA_TAB_SUBPARTITIONS)
GLOBAL_STATS (ALL_TAB_PARTITIONS)
GLOBAL_STATS (USER_PART_COL_STATISTICS)
GLOBAL_STATS (ALL_ALL_TABLES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (DBA_IND_PARTITIONS)
GLOBAL_STATS (USER_TABLES)	Are the statistics calculated without merging underlying partitions?
GLOBAL_STATS (DBA_TABLES)	Are the statistics calculated without merging underlying partitions?
STATISTIC (GV$PQ_SYSSTAT)
STATISTIC (V$PQ_SYSSTAT)
STATISTIC (V$PX_PROCESS_SYSSTAT)
STATISTIC (V$PQ_SESSTAT)
STATISTIC (GV$PX_PROCESS_SYSSTAT)
STATISTIC (GV$PQ_SESSTAT)
STATISTIC# (V$PX_SESSTAT)
STATISTIC# (GV$STATNAME)
STATISTIC# (V$STATNAME)
STATISTIC# (GV$SEGSTAT)
STATISTIC# (GV$MYSTAT)
STATISTIC# (GV$SESSTAT)
STATISTIC# (V$SEGMENT_STATISTICS)
STATISTIC# (V$MYSTAT)
STATISTIC# (GV$SYSSTAT)
STATISTIC# (GV$SEGMENT_STATISTICS)
STATISTIC# (GV$PX_SESSTAT)
STATISTIC# (GV$DLM_MISC)
STATISTIC# (GV$SEGSTAT_NAME)
STATISTIC# (V$SEGSTAT_NAME)
STATISTIC# (V$DLM_MISC)
STATISTIC# (V$SYSSTAT)
STATISTIC# (V$SESSTAT)
STATISTIC# (V$SEGSTAT)
STATISTICS (DBA_USTATS)	User collected statistics for the object
STATISTICS (ALL_USTATS)	User collected statistics for the object
STATISTICS (USER_USTATS)	User collected statistics for the object
STATISTICS_NAME (GV$STATISTICS_LEVEL)
STATISTICS_NAME (V$STATISTICS_LEVEL)
STATISTICS_VIEW_NAME (GV$STATISTICS_LEVEL)
STATISTICS_VIEW_NAME (V$STATISTICS_LEVEL)
STATISTIC_NAME (V$SEGMENT_STATISTICS)
STATISTIC_NAME (GV$SEGMENT_STATISTICS)
STATISTIC_NAME (GV$SEGSTAT)
STATISTIC_NAME (V$SEGSTAT)
STATS_ROW_MISMATCH (V$SQL_SHARED_CURSOR)
STATS_ROW_MISMATCH (GV$SQL_SHARED_CURSOR)
USER_STATS (IND)	Were the statistics entered directly by the user?
USER_STATS (USER_ALL_TABLES)	Were the statistics entered directly by the user?
USER_STATS (ALL_SUBPART_COL_STATISTICS)
USER_STATS (DBA_PART_COL_STATISTICS)
USER_STATS (ALL_IND_PARTITIONS)
USER_STATS (USER_TABLES)	Were the statistics entered directly by the user?
USER_STATS (DBA_TAB_PARTITIONS)
USER_STATS (DBA_IND_PARTITIONS)
USER_STATS (USER_PART_COL_STATISTICS)
USER_STATS (ALL_ALL_TABLES)	Were the statistics entered directly by the user?
USER_STATS (ALL_TAB_PARTITIONS)
USER_STATS (DBA_TAB_SUBPARTITIONS)
USER_STATS (USER_OBJECT_TABLES)	Were the statistics entered directly by the user?
USER_STATS (DBA_TAB_COLUMNS)	Were the statistics entered directly by the user?
USER_STATS (USER_TAB_PARTITIONS)
USER_STATS (DBA_TAB_COLS)	Were the statistics entered directly by the user?
USER_STATS (DBA_TAB_COL_STATISTICS)	Were the statistics entered directly by the user?
USER_STATS (DBA_OBJECT_TABLES)	Were the statistics entered directly by the user?
USER_STATS (ALL_TAB_COLUMNS)	Were the statistics entered directly by the user?
USER_STATS (ALL_PART_COL_STATISTICS)
USER_STATS (ALL_IND_SUBPARTITIONS)
USER_STATS (ALL_INDEXES)	Were the statistics entered directly by the user?
USER_STATS (DBA_SUBPART_COL_STATISTICS)
USER_STATS (TABS)	Were the statistics entered directly by the user?
USER_STATS (DBA_TABLES)	Were the statistics entered directly by the user?
USER_STATS (USER_IND_SUBPARTITIONS)
USER_STATS (DBA_INDEXES)	Were the statistics entered directly by the user?
USER_STATS (USER_IND_PARTITIONS)
USER_STATS (USER_TAB_SUBPARTITIONS)
USER_STATS (USER_INDEXES)	Were the statistics entered directly by the user?
USER_STATS (ALL_TABLES)	Were the statistics entered directly by the user?
USER_STATS (COLS)	Were the statistics entered directly by the user?
USER_STATS (ALL_TAB_COLS)	Were the statistics entered directly by the user?
USER_STATS (DBA_IND_SUBPARTITIONS)
USER_STATS (ALL_OBJECT_TABLES)	Were the statistics entered directly by the user?
USER_STATS (DBA_ALL_TABLES)	Were the statistics entered directly by the user?
USER_STATS (ALL_TAB_SUBPARTITIONS)
USER_STATS (USER_TAB_COLUMNS)	Were the statistics entered directly by the user?
USER_STATS (USER_SUBPART_COL_STATISTICS)
USER_STATS (ALL_TAB_COL_STATISTICS)	Were the statistics entered directly by the user?
USER_STATS (USER_TAB_COL_STATISTICS)	Were the statistics entered directly by the user?
USER_STATS (USER_TAB_COLS)	Were the statistics entered directly by the user?

top back to index

Comment on this page:

home - keyword index