Oracle 11gR2 new AWR views and columns as compared to 10gR2

New AWR views:

VIEW_NAME
DBA_HIST_ASH_SNAPSHOT
DBA_HIST_BASELINE_DETAILS
DBA_HIST_BASELINE_METADATA
DBA_HIST_BASELINE_TEMPLATE
DBA_HIST_CLUSTER_INTERCON
DBA_HIST_COLORED_SQL
DBA_HIST_DISPATCHER
DBA_HIST_DYN_REMASTER_STATS
DBA_HIST_EVENT_HISTOGRAM
DBA_HIST_IC_CLIENT_STATS
DBA_HIST_IC_DEVICE_STATS
DBA_HIST_INTERCONNECT_PINGS
DBA_HIST_IOSTAT_DETAIL
DBA_HIST_IOSTAT_FILETYPE
DBA_HIST_IOSTAT_FILETYPE_NAME
DBA_HIST_IOSTAT_FUNCTION
DBA_HIST_IOSTAT_FUNCTION_NAME
DBA_HIST_MEMORY_RESIZE_OPS
DBA_HIST_MEMORY_TARGET_ADVICE
DBA_HIST_MEM_DYNAMIC_COMP
DBA_HIST_MUTEX_SLEEP
DBA_HIST_MVPARAMETER
DBA_HIST_PERSISTENT_QMN_CACHE
DBA_HIST_PERSISTENT_QUEUES
DBA_HIST_PERSISTENT_SUBS
DBA_HIST_PLAN_OPERATION_NAME
DBA_HIST_PLAN_OPTION_NAME
DBA_HIST_RSRC_CONSUMER_GROUP
DBA_HIST_RSRC_PLAN
DBA_HIST_SHARED_SERVER_SUMMARY
DBA_HIST_SQLCOMMAND_NAME
DBA_HIST_TABLESPACE
DBA_HIST_TOPLEVELCALL_NAME

New AWR view columns:

VIEW_NAME COLUMN_NAME
DBA_HIST_ACTIVE_SESS_HISTORY IS_SQLID_CURRENT
SQL_OPNAME
TOP_LEVEL_SQL_ID
TOP_LEVEL_SQL_OPCODE
SQL_PLAN_LINE_ID
SQL_PLAN_OPERATION
SQL_PLAN_OPTIONS
SQL_EXEC_ID
SQL_EXEC_START
QC_SESSION_SERIAL#
PX_FLAGS
BLOCKING_INST_ID
BLOCKING_HANGCHAIN_INFO
CURRENT_ROW#
TOP_LEVEL_CALL#
TOP_LEVEL_CALL_NAME
CONSUMER_GROUP_ID
REMOTE_INSTANCE#
TIME_MODEL
IN_CONNECTION_MGMT
IN_PARSE
IN_HARD_PARSE
IN_SQL_EXECUTION
IN_PLSQL_EXECUTION
IN_PLSQL_RPC
IN_PLSQL_COMPILATION
IN_JAVA_EXECUTION
IN_BIND
IN_CURSOR_CLOSE
IN_SEQUENCE_LOAD
CAPTURE_OVERHEAD
REPLAY_OVERHEAD
IS_CAPTURED
IS_REPLAYED
MACHINE
PORT
ECID
DBREPLAY_FILE_ID
DBREPLAY_CALL_COUNTER
TM_DELTA_TIME
TM_DELTA_CPU_TIME
TM_DELTA_DB_TIME
DELTA_TIME
DELTA_READ_IO_REQUESTS
DELTA_WRITE_IO_REQUESTS
DELTA_READ_IO_BYTES
DELTA_WRITE_IO_BYTES
DELTA_INTERCONNECT_IO_BYTES
PGA_ALLOCATED
TEMP_SPACE_ALLOCATED
DBA_HIST_BASELINE BASELINE_TYPE
MOVING_WINDOW_SIZE
CREATION_TIME
EXPIRATION
TEMPLATE_NAME
LAST_TIME_COMPUTED
DBA_HIST_BUFFERED_QUEUES EXPIRED_MSGS
OLDEST_MSGID
OLDEST_MSG_ENQTM
QUEUE_STATE
ELAPSED_ENQUEUE_TIME
ELAPSED_DEQUEUE_TIME
ELAPSED_TRANSFORMATION_TIME
ELAPSED_RULE_EVALUATION_TIME
ENQUEUE_CPU_TIME
DEQUEUE_CPU_TIME
LAST_ENQUEUE_TIME
LAST_DEQUEUE_TIME
DBA_HIST_BUFFERED_SUBSCRIBERS LAST_BROWSED_SEQ
LAST_BROWSED_NUM
LAST_DEQUEUED_SEQ
LAST_DEQUEUED_NUM
CURRENT_ENQ_SEQ
TOTAL_DEQUEUED_MSG
EXPIRED_MSGS
MESSAGE_LAG
ELAPSED_DEQUEUE_TIME
DEQUEUE_CPU_TIME
LAST_DEQUEUE_TIME
OLDEST_MSGID
OLDEST_MSG_ENQTM
DBA_HIST_DATABASE_INSTANCE PLATFORM_NAME
DBA_HIST_DB_CACHE_ADVICE ESTD_PHYSICAL_READ_TIME
DBA_HIST_INST_CACHE_TRANSFER LOST
CR_2HOP
CR_3HOP
CURRENT_2HOP
CURRENT_3HOP
CR_BLOCK_TIME
CR_BUSY_TIME
CR_CONGESTED_TIME
CURRENT_BLOCK_TIME
CURRENT_BUSY_TIME
CURRENT_CONGESTED_TIME
LOST_TIME
CR_2HOP_TIME
CR_3HOP_TIME
CURRENT_2HOP_TIME
CURRENT_3HOP_TIME
DBA_HIST_PGA_TARGET_ADVICE ESTD_TIME
DBA_HIST_SEG_STAT CHAIN_ROW_EXCESS_TOTAL
CHAIN_ROW_EXCESS_DELTA
PHYSICAL_READ_REQUESTS_TOTAL
PHYSICAL_READ_REQUESTS_DELTA
PHYSICAL_WRITE_REQUESTS_TOTAL
PHYSICAL_WRITE_REQUESTS_DELTA
OPTIMIZED_PHYSICAL_READS_TOTAL
OPTIMIZED_PHYSICAL_READS_DELTA
DBA_HIST_SNAPSHOT SNAP_FLAG
SNAP_TIMEZONE
DBA_HIST_SQLSTAT PARSING_USER_ID
IO_OFFLOAD_ELIG_BYTES_TOTAL
IO_OFFLOAD_ELIG_BYTES_DELTA
IO_INTERCONNECT_BYTES_TOTAL
IO_INTERCONNECT_BYTES_DELTA
PHYSICAL_READ_REQUESTS_TOTAL
PHYSICAL_READ_REQUESTS_DELTA
PHYSICAL_READ_BYTES_TOTAL
PHYSICAL_READ_BYTES_DELTA
PHYSICAL_WRITE_REQUESTS_TOTAL
PHYSICAL_WRITE_REQUESTS_DELTA
PHYSICAL_WRITE_BYTES_TOTAL
PHYSICAL_WRITE_BYTES_DELTA
OPTIMIZED_PHYSICAL_READS_TOTAL
OPTIMIZED_PHYSICAL_READS_DELTA
CELL_UNCOMPRESSED_BYTES_TOTAL
CELL_UNCOMPRESSED_BYTES_DELTA
IO_OFFLOAD_RETURN_BYTES_TOTAL
IO_OFFLOAD_RETURN_BYTES_DELTA
FLAG
DBA_HIST_SYSMETRIC_SUMMARY SUM_SQUARES
DBA_HIST_SYSTEM_EVENT TOTAL_WAITS_FG
TOTAL_TIMEOUTS_FG
TIME_WAITED_MICRO_FG
DBA_HIST_WAITCLASSMET_HISTORY TIME_WAITED_FG
WAIT_COUNT_FG
This entry was posted in Uncategorized. Bookmark the permalink.

2 Responses to Oracle 11gR2 new AWR views and columns as compared to 10gR2

  1. Pingback: 11.2 New views « Oracle Scratchpad

  2. Pingback: Log Buffer #258, A Carnival of the Vanities for DBAs | The Pythian Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s