Compare 9i Statspack & 10g AWR Views
Statspack | AWR | |||
STATS$DATABASE_INSTANCE | Tables store historical data or snapshots | |||
STATS$IDLE_EVENT | ||||
STATS$LEVEL_DESCRIPTION | ||||
STATS$ROLLSTAT | ||||
STATS$SESSION_EVENT | ||||
STATS$SNAPSHOT | ||||
STATS$SQL_PLAN_USAGE | ||||
STATS$SQL_SUMMARY | WRH$_ACTIVE_SESSION_HISTORY | WRI$_ADV_ACTIONS | ||
STATS$STATSPACK_PARAMETER | WRH$_ACTIVE_SESSION_HISTORY_BL | WRI$_ADV_ASA_RECO_DATA | ||
STATS$BG_EVENT_SUMMARY | WRH$_BG_EVENT_SUMMARY | WRI$_ADV_DEFINITIONS | ||
WRH$_BUFFERED_QUEUES | WRI$_ADV_DEF_PARAMETERS | |||
WRH$_BUFFERED_SUBSCRIBERS | WRI$_ADV_DIRECTIVES | |||
STATS$BUFFER_POOL_STATISTICS | WRH$_BUFFER_POOL_STATISTICS | WRI$_ADV_FINDINGS | ||
WRH$_COMP_IOSTAT | WRI$_ADV_JOURNAL | |||
WRH$_CR_BLOCK_SERVER | WRI$_ADV_MESSAGE_GROUPS | |||
WRH$_CURRENT_BLOCK_SERVER | WRI$_ADV_OBJECTS | |||
WRH$_DATAFILE | WRI$_ADV_PARAMETERS | |||
STATS$DB_CACHE_ADVICE | WRH$_DB_CACHE_ADVICE | WRI$_ADV_RATIONALE | ||
WRH$_DB_CACHE_ADVICE_BL | WRI$_ADV_RECOMMENDATIONS | |||
STATS$DLM_MISC | WRH$_DLM_MISC | WRI$_ADV_REC_ACTIONS | ||
WRH$_DLM_MISC_BL | WRI$_ADV_SQLA_FAKE_REG | |||
STATS$ENQUEUE_STAT | WRH$_ENQUEUE_STAT | WRI$_ADV_SQLA_MAP | ||
WRH$_EVENT_NAME | WRI$_ADV_SQLA_STMTS | |||
WRH$_FILEMETRIC_HISTORY | WRI$_ADV_SQLA_TMP | |||
STATS$FILESTATXS | WRH$_FILESTATXS | WRI$_ADV_SQLT_BINDS | ||
WRH$_FILESTATXS_BL | WRI$_ADV_SQLT_PLANS | |||
STATS$INSTANCE_RECOVERY | WRH$_INSTANCE_RECOVERY | WRI$_ADV_SQLT_RTN_PLAN | ||
WRH$_INST_CACHE_TRANSFER | WRI$_ADV_SQLT_STATISTICS | |||
WRH$_INST_CACHE_TRANSFER_BL | WRI$_ADV_SQLW_COLVOL | |||
WRH$_JAVA_POOL_ADVICE | WRI$_ADV_SQLW_STMTS | |||
STATS$LATCH | WRH$_LATCH | WRI$_ADV_SQLW_SUM | ||
WRH$_LATCH_BL | WRI$_ADV_SQLW_TABLES | |||
STATS$LATCH_CHILDREN | WRH$_LATCH_CHILDREN | WRI$_ADV_SQLW_TABVOL | ||
WRH$_LATCH_CHILDREN_BL | WRI$_ADV_TASKS | |||
STATS$LATCH_MISSES_SUMMARY | WRH$_LATCH_MISSES_SUMMARY | WRI$_ADV_USAGE | ||
WRH$_LATCH_MISSES_SUMMARY_BL | WRI$_AGGREGATION_ENABLED | |||
WRH$_LATCH_NAME | WRI$_ALERT_HISTORY | |||
STATS$LATCH_PARENT | WRH$_LATCH_PARENT | WRI$_ALERT_OUTSTANDING | ||
WRH$_LATCH_PARENT_BL | WRI$_ALERT_THRESHOLD | |||
STATS$LIBRARYCACHE | WRH$_LIBRARYCACHE | WRI$_ALERT_THRESHOLD_LOG | ||
WRH$_LOG | WRI$_DBU_CPU_USAGE | |||
WRH$_METRIC_NAME | WRI$_DBU_CPU_USAGE_SAMPLE | |||
WRH$_MTTR_TARGET_ADVICE | WRI$_DBU_FEATURE_METADATA | |||
WRH$_OPTIMIZER_ENV | WRI$_DBU_FEATURE_USAGE | |||
WRH$_OSSTAT | WRI$_DBU_HIGH_WATER_MARK | |||
WRH$_OSSTAT_BL | WRI$_DBU_HWM_METADATA | |||
WRH$_OSSTAT_NAME | WRI$_DBU_USAGE_SAMPLE | |||
STATS$PARAMETER | WRH$_PARAMETER | WRI$_OPTSTAT_AUX_HISTORY | ||
WRH$_PARAMETER_BL | WRI$_OPTSTAT_HISTGRM_HISTORY | |||
WRH$_PARAMETER_NAME | WRI$_OPTSTAT_HISTHEAD_HISTORY | |||
STATS$PGASTAT | WRH$_PGASTAT | WRI$_OPTSTAT_IND_HISTORY | ||
STATS$PGA_TARGET_ADVICE | WRH$_PGA_TARGET_ADVICE | WRI$_OPTSTAT_OPR | ||
WRH$_PROCESS_MEMORY_SUMMARY | WRI$_OPTSTAT_TAB_HISTORY | |||
STATS$RESOURCE_LIMIT | WRH$_RESOURCE_LIMIT | WRI$_SCH_CONTROL | ||
STATS$ROWCACHE_SUMMARY | WRH$_ROWCACHE_SUMMARY | WRI$_SCH_VOTES | ||
WRH$_ROWCACHE_SUMMARY_BL | WRI$_SEGADV_CNTRLTAB | |||
WRH$_RULE_SET | WRI$_SEGADV_OBJLIST | |||
WRH$_SEG_STAT | WRI$_SQLSET_BINDS | |||
WRH$_SEG_STAT_BL | WRI$_SQLSET_DEFINITIONS | |||
STATS$SEG_STAT_OBJ | WRH$_SEG_STAT_OBJ | WRI$_SQLSET_MASK | ||
WRH$_SERVICE_NAME | WRI$_SQLSET_PLANS | |||
WRH$_SERVICE_STAT | WRI$_SQLSET_PLANS_TOCAP | |||
WRH$_SERVICE_STAT_BL | WRI$_SQLSET_PLAN_LINES | |||
WRH$_SERVICE_WAIT_CLASS | WRI$_SQLSET_REFERENCES | |||
WRH$_SERVICE_WAIT_CLASS_BL | WRI$_SQLSET_STATEMENTS | |||
WRH$_SESSMETRIC_HISTORY | WRI$_SQLSET_STATISTICS | |||
STATS$SESSTAT | WRH$_SESS_TIME_STATS | WRI$_SQLSET_WORKSPACE | ||
STATS$SGA | WRH$_SGA | WRI$_TRACING_ENABLED | ||
STATS$SEG_STAT , STATS$SGASTAT | WRH$_SGASTAT | |||
WRH$_SGASTAT_BL | ||||
WRH$_SGA_TARGET_ADVICE | ||||
STATS$SHARED_POOL_ADVICE | WRH$_SHARED_POOL_ADVICE | |||
STATS$SQL_STATISTICS | WRH$_SQLSTAT | |||
WRH$_SQLSTAT_BL | ||||
STATS$SQLTEXT | WRH$_SQLTEXT | |||
WRH$_SQL_BIND_METADATA | ||||
STATS$SQL_PLAN | WRH$_SQL_PLAN | |||
WRH$_SQL_SUMMARY | ||||
STATS$SQL_WORKAREA_HISTOGRAM | WRH$_SQL_WORKAREA_HISTOGRAM | |||
WRH$_STAT_NAME | ||||
WRH$_STREAMS_APPLY_SUM | ||||
WRH$_STREAMS_CAPTURE | ||||
WRH$_STREAMS_POOL_ADVICE | ||||
WRH$_SYSMETRIC_HISTORY | ||||
WRH$_SYSMETRIC_SUMMARY | ||||
STATS$SYSSTAT | WRH$_SYSSTAT | |||
WRH$_SYSSTAT_BL | ||||
STATS$SYSTEM_EVENT | WRH$_SYSTEM_EVENT | |||
WRH$_SYSTEM_EVENT_BL | ||||
WRH$_SYS_TIME_MODEL | ||||
WRH$_SYS_TIME_MODEL_BL | ||||
WRH$_TABLESPACE_SPACE_USAGE | ||||
WRH$_TABLESPACE_STAT | ||||
WRH$_TABLESPACE_STAT_BL | ||||
WRH$_TEMPFILE | ||||
STATS$TEMPSTATXS | WRH$_TEMPSTATXS | |||
WRH$_THREAD | ||||
STATS$UNDOSTAT | WRH$_UNDOSTAT | |||
WRH$_WAITCLASSMETRIC_HISTORY | ||||
STATS$WAITSTAT | WRH$_WAITSTAT | |||
WRH$_WAITSTAT_BL | ||||