New AWR views:
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 |
Pingback: 11.2 New views « Oracle Scratchpad
Pingback: Log Buffer #258, A Carnival of the Vanities for DBAs | The Pythian Blog