WLM_QUEUE_TIME_TOTAL |
wlm_queue_time_total - Workload manager
total queue time |
WLM_QUEUE_ASSIGNMENTS_TOTAL |
wlm_queue_assignments_total - Workload
manager total queue assignments |
FCM_TQ_RECV_WAIT_TIME |
fcm_tq_recv_wait_time - FCM table queue
received wait time |
FCM_MESSAGE_RECV_WAIT_TIME |
fcm_message_recv_wait_time - FCM message
received wait time |
FCM_TQ_SEND_WAIT_TIME |
fcm_tq_send_wait_time - FCM table queue
send wait time |
FCM_MESSAGE_SEND_WAIT_TIME |
fcm_message_send_wait_time - FCM message
send wait time |
AGENT_WAIT_TIME |
agent_wait_time - Agent wait time |
AGENT_WAITS_TOTAL |
agent_waits_total - Total agent waits |
LOCK_WAIT_TIME |
lock_wait_time - Time waited on locks |
LOCK_WAITS |
lock_waits - Lock waits |
DIRECT_READ_TIME |
direct_read_time - Direct read time |
DIRECT_READ_REQS |
direct_read_reqs - Direct read requests |
DIRECT_WRITE_TIME |
direct_write_time - Direct write time |
DIRECT_WRITE_REQS |
direct_write_reqs - Direct write requests |
LOG_BUFFER_WAIT_TIME |
log_buffer_wait_time - Log buffer wait
time |
NUM_LOG_BUFFER_FULL |
num_log_buffer_full - Number of times
full log buffer caused agents to wait |
LOG_DISK_WAIT_TIME |
log_disk_wait_time - Log disk wait
time |
LOG_DISK_WAITS_TOTAL |
log_disk_waits_total - Total log disk
waits |
TCPIP_RECV_WAIT_TIME |
tcpip_recv_wait_time - TCP/IP received
wait time |
TCPIP_RECVS_TOTAL |
tcpip_recvs_total - TCP/IP receives
total |
CLIENT_IDLE_WAIT_TIME |
client_idle_wait_time - Client idle
wait time |
IPC_RECV_WAIT_TIME |
ipc_recv_wait_time - Interprocess communication
received wait time |
IPC_RECVS_TOTAL |
ipc_recvs_total - Interprocess communication
receives total |
IPC_SEND_WAIT_TIME |
ipc_send_wait_time - Interprocess communication
send wait time |
IPC_SENDS_TOTAL |
ipc_sends_total - Interprocess communication
send total |
TCPIP_SEND_WAIT_TIME |
tcpip_send_wait_time - TCP/IP send
wait time |
TCPIP_SENDS_TOTAL |
tcpip_sends_total - TCP/IP sends total |
POOL_WRITE_TIME |
pool_write_time - Total buffer pool
physical write time |
POOL_READ_TIME |
pool_read_time - Total buffer pool
physical read time |
AUDIT_FILE_WRITE_WAIT_TIME |
audit_file_write_wait_time - Audit
file write wait time |
AUDIT_FILE_WRITES_TOTAL |
audit_file_writes_total - Total audit
files written |
AUDIT_SUBSYSTEM_WAIT_TIME |
audit_subsystem_wait_time - Audit subsystem
wait time |
AUDIT_SUBSYSTEM_WAITS_TOTAL |
audit_subsystem_waits_total - Total
audit subsystem waits |
DIAGLOG_WRITE_WAIT_TIME |
diaglog_write_wait_time - Diagnostic
log file write wait time |
DIAGLOG_WRITES_TOTAL |
diaglog_writes_total - Total diagnostic
log file writes |
FCM_SEND_WAIT_TIME |
fcm_send_wait_time - FCM send wait
time |
FCM_RECV_WAIT_TIME |
fcm_recv_wait_time - FCM received wait
time |
TOTAL_ACT_WAIT_TIME |
total_act_wait_time - Total activity
wait time |
TOTAL_WAIT_TIME |
total_wait_time - Total wait time |
LOCK_WAIT_TIME_GLOBAL |
lock_wait_time_global - Lock wait time
global |
LOCK_WAITS_GLOBAL |
lock_waits_global - Lock waits global |
RECLAIM_WAIT_TIME |
reclaim_wait_time - Reclaim wait time |
SPACEMAPPAGE_RECLAIM_WAIT_TIME |
spacemappage_reclaim_wait_time - Space
map page reclaim wait time |
CF_WAIT_TIME |
cf_wait_time - cluster caching facility
wait time |
CF_WAITS |
cf_waits - Number of cluster caching
facility waits |
EVMON_WAIT_TIME |
evmon_wait_time - Event monitor wait
time |
EVMON_WAITS_TOTAL |
evmon_waits_total - Event monitor total
waits |
TOTAL_EXTENDED_LATCH_WAIT_TIME |
total_extended_latch_wait_time - Total
extended latch wait time |
TOTAL_EXTENDED_LATCH_WAITS |
total_extended_latch_waits - Total
extended latch waits |
PREFETCH_WAIT_TIME |
prefetch_wait_time - Time waited for
prefetch |
PREFETCH_WAITS |
prefetch_waits - Prefetcher wait count |
COMM_EXIT_WAIT_TIME |
comm_exit_wait_time - Communication
buffer exit wait time monitor element |
COMM_EXIT_WAITS |
comm_exit_waits - Communication buffer
exit number of waits monitor element |
TOTAL_RQST_TIME |
total_rqst_time - Total request time |
RQSTS_COMPLETED_TOTAL |
rqsts_completed_total - Total requests
completed |
TOTAL_APP_RQST_TIME |
total_app_rqst_time - Total application
request time |
APP_RQSTS_COMPLETED_TOTAL |
app_rqsts_completed_total - Total application
requests completed |
TOTAL_SECTION_SORT_PROC_TIME |
total_section_sort_proc_time - Total
section sort processing time |
TOTAL_SECTION_SORT_TIME |
total_section_sort_time - Total section
sort time |
TOTAL_SECTION_SORTS |
total_section_sorts - Total section
sorts |
TOTAL_ACT_TIME |
total_act_time - Total activity time |
TOTAL_ROUTINE_TIME |
total_routine_time - Total routine
time |
TOTAL_COMPILE_PROC_TIME |
total_compile_proc_time - Total compile
processing time |
TOTAL_COMPILE_TIME |
total_compile_time - Total compile
time |
TOTAL_COMPILATIONS |
total_compilations - Total compilations |
TOTAL_IMPLICIT_COMPILE_PROC_TIME |
total_implicit_compile_proc_time -
Total implicit compile processing time |
TOTAL_IMPLICIT_COMPILE_TIME |
total_implicit_compile_time - Total
implicit compile time |
TOTAL_IMPLICIT_COMPILATIONS |
total_implicit_compilations - Total
implicit complications |
TOTAL_RUNSTATS_PROC_TIME |
total_runstats_proc_time - Total runtime
statistics processing time |
TOTAL_RUNSTATS_TIME |
total_runstats_time - Total runtime
statistics time |
TOTAL_RUNSTATS |
total_runstats - Total runtime statistics |
TOTAL_REORG_PROC_TIME |
total_reorg_proc_time - Total reorganization
processing time |
TOTAL_REORG_TIME |
total_reorg_time - Total reorganization
time |
TOTAL_REORGS |
total_reorgs - Total reorganizations |
TOTAL_LOAD_PROC_TIME |
total_load_proc_time - Total load processing
time |
TOTAL_LOAD_TIME |
total_load_time - Total load time |
TOTAL_LOADS |
total_loads - Total loads |
TOTAL_SECTION_PROC_TIME |
total_section_proc_time - Total section
processing time |
TOTAL_SECTION_TIME |
total_section_time - Total section
time |
TOTAL_APP_SECTION_EXECUTIONS |
total_app_section_executions - Total
application section executions |
TOTAL_COMMIT_PROC_TIME |
total_commit_proc_time - Total commits
processing time |
TOTAL_COMMIT_TIME |
total_commit_time - Total commit time |
TOTAL_APP_COMMITS |
total_app_commits - Total application
commits |
TOTAL_ROLLBACK_PROC_TIME |
total_rollback_proc_time - Total rollback
processing time |
TOTAL_ROLLBACK_TIME |
total_rollback_time - Total rollback
time |
TOTAL_APP_ROLLBACKS |
total_app_rollbacks - Total application
rollbacks |
TOTAL_ROUTINE_USER_CODE_PROC_TIME |
total_routine_user_code_proc_time -
Total routine user code processing time |
TOTAL_ROUTINE_USER_CODE_TIME |
total_routine_user_code_time - Total
routine user code time |
TOTAL_STATS_FABRICATION_PROC_TIME |
total_stats_fabrication_proc_time -
Total statistics fabrication processing time |
TOTAL_STATS_FABRICATION_TIME |
total_stats_fabrication_time - Total
statistics fabrication time |
TOTAL_STATS_FABRICATIONS |
total_stats_fabrications - Total statistics
fabrications |
TOTAL_SYNC_RUNSTATS_PROC_TIME |
total_sync_runstats_proc_time - Total
synchronous RUNSTATS processing time |
TOTAL_SYNC_RUNSTATS_TIME |
total_sync_runstats_time - Total synchronous
RUNSTATS time |
TOTAL_SYNC_RUNSTATS |
total_sync_runstats - Total synchronous
RUNSTATS activities |
TOTAL_CONNECT_REQUEST_PROC_TIME |
total_connect_request_proc_time - Total
connection or switch user request processing time |
TOTAL_CONNECT_REQUEST_TIME |
total_connect_request_time - Total
connection or switch user request time |
TOTAL_CONNECT_REQUESTS |
total_connect_requests - Connection
or switch user requests |
TOTAL_CONNECT_AUTHENTICATION_PROC_TIME |
total_connect_authentication_proc_time
- Total connection authentication processing time |
TOTAL_CONNECT_AUTHENTICATION_TIME |
total_connect_authentication_time -
Total connection or switch user authentication request time |
TOTAL_CONNECT_AUTHENTICATIONS |
total_connect_authentications - Connections
or switch user authentications performed |
ROWS_READ |
rows_read - Rows read |
ROWS_MODIFIED |
rows_modified - Rows modified |
POOL_DATA_L_READS |
pool_data_l_reads - Buffer pool data
logical reads |
POOL_INDEX_L_READS |
pool_index_l_reads - Buffer pool index
logical reads |
POOL_TEMP_DATA_L_READS |
pool_temp_data_l_reads - Buffer pool
temporary data logical reads |
POOL_TEMP_INDEX_L_READS |
pool_temp_index_l_reads - Buffer pool
temporary index logical reads |
POOL_XDA_L_READS |
pool_xda_l_reads - Buffer pool XDA
data logical reads |
POOL_TEMP_XDA_L_READS |
pool_temp_xda_l_reads - Buffer pool
temporary XDA data logical reads |
TOTAL_CPU_TIME |
total_cpu_time - Total CPU time |
ACT_COMPLETED_TOTAL |
act_completed_total - Total completed
activities |
CAT_CACHE_LOOKUPS |
cat_cache_lookups - Catalog cache lookups |
PKG_CACHE_LOOKUPS |
pkg_cache_lookups - Package cache lookups |
POOL_DATA_P_READS |
pool_data_p_reads - Buffer pool data
physical reads |
POOL_TEMP_DATA_P_READS |
pool_temp_data_p_reads - Buffer pool
temporary data physical reads |
POOL_XDA_P_READS |
pool_xda_p_reads - Buffer pool XDA
data physical reads |
POOL_TEMP_XDA_P_READS |
pool_temp_xda_p_reads - Buffer pool
temporary XDA data physical reads |
POOL_INDEX_P_READS |
pool_index_p_reads - Buffer pool index
physical reads |
POOL_TEMP_INDEX_P_READS |
pool_temp_index_p_reads - Buffer pool
temporary index physical reads |
POOL_DATA_WRITES |
pool_data_writes - Buffer pool data
writes |
POOL_XDA_WRITES |
pool_xda_writes - Buffer pool XDA data
writes |
POOL_INDEX_WRITES |
pool_index_writes - Buffer pool index
writes |
DIRECT_READS |
direct_reads - Direct reads from database |
DIRECT_WRITES |
direct_writes - Direct writes to database |
ROWS_RETURNED |
rows_returned - Rows returned |
DEADLOCKS |
deadlocks - Deadlocks detected |
LOCK_TIMEOUTS |
lock_timeouts - Number of lock timeouts |
LOCK_ESCALS |
lock_escals - Number of lock escalations |
FCM_SENDS_TOTAL |
fcm_sends_total - FCM sends total |
FCM_RECVS_TOTAL |
fcm_recvs_total - FCM receives total |
FCM_SEND_VOLUME |
fcm_send_volume - FCM send volume |
FCM_RECV_VOLUME |
fcm_recv_volume - FCM received volume |
FCM_MESSAGE_SENDS_TOTAL |
fcm_message_sends_total - Total FCM
message sends |
FCM_MESSAGE_RECVS_TOTAL |
fcm_message_recvs_total - Total FCM
message receives |
FCM_MESSAGE_SEND_VOLUME |
fcm_message_send_volume - FCM message
send volume |
FCM_MESSAGE_RECV_VOLUME |
fcm_message_recv_volume - FCM message
received volume |
FCM_TQ_SENDS_TOTAL |
fcm_tq_sends_total - FCM table queue
send total |
FCM_TQ_RECVS_TOTAL |
fcm_tq_recvs_total - FCM table queue
receives total |
FCM_TQ_SEND_VOLUME |
fcm_tq_send_volume - FCM table queue
send volume |
FCM_TQ_RECV_VOLUME |
fcm_tq_recv_volume - FCM table queue
received volume |
TQ_TOT_SEND_SPILLS |
tq_tot_send_spills - Total number of
table queue buffers overflowed |
TCPIP_SEND_VOLUME |
tcpip_send_volume - TCP/IP send volume |
TCPIP_RECV_VOLUME |
tcpip_recv_volume - TCP/IP received
volume |
IPC_SEND_VOLUME |
ipc_send_volume - Interprocess communication
send volume |
IPC_RECV_VOLUME |
ipc_recv_volume - Interprocess communication
received volume |
POST_THRESHOLD_SORTS |
post_threshold_sorts - Post threshold
sorts |
POST_SHRTHRESHOLD_SORTS |
post_shrthreshold_sorts - Post shared
threshold sorts |
SORT_OVERFLOWS |
sort_overflows - Sort overflows |
AUDIT_EVENTS_TOTAL |
audit_events_total - Total audit events |
ACT_REJECTED_TOTAL |
act_rejected_total - Total rejected
activities |
ACT_ABORTED_TOTAL |
act_aborted_total - Total aborted activities |
TOTAL_SORTS |
total_sorts - Total sorts |
LOCK_TIMEOUTS_GLOBAL |
lock_timeouts_global - Lock timeouts
global |
LOCK_ESCALS_MAXLOCKS |
lock_escals_maxlocks - Number of maxlocks
lock escalations |
LOCK_ESCALS_LOCKLIST |
lock_escals_locklist - Number of locklist
lock escalations |
LOCK_ESCALS_GLOBAL |
lock_escals_global - Number of global
lock escalations |
POOL_DATA_GBP_L_READS |
pool_data_gbp_l_reads - Group buffer
pool data logical reads |
POOL_DATA_GBP_P_READS |
pool_data_gbp_p_reads - Group buffer
pool data physical reads |
POOL_DATA_LBP_PAGES_FOUND |
pool_data_lbp_pages_found - Local buffer
pool found data pages |
POOL_DATA_GBP_INVALID_PAGES |
pool_data_gbp_invalid_pages - Group
buffer pool invalid data pages |
POOL_INDEX_GBP_L_READS |
pool_index_gbp_l_reads - Group buffer
pool index logical reads |
POOL_INDEX_GBP_P_READS |
pool_index_gbp_p_reads - Group buffer
pool index physical reads |
POOL_INDEX_LBP_PAGES_FOUND |
pool_index_lbp_pages_found - Local
buffer pool index pages found |
POOL_INDEX_GBP_INVALID_PAGES |
pool_index_gbp_invalid_pages - Group
buffer pool invalid index pages |
POOL_XDA_GBP_L_READS |
pool_xda_gbp_l_reads - Group buffer
pool XDA data logical read requests |
POOL_XDA_GBP_P_READS |
pool_xda_gbp_p_reads - Group buffer
pool XDA data physical read requests |
POOL_XDA_LBP_PAGES_FOUND |
pool_xda_lbp_pages_found - Local buffer
pool XDA data pages found |
POOL_XDA_GBP_INVALID_PAGES |
pool_xda_gbp_invalid_pages - Group
buffer pool invalid XDA data pages |
THRESH_VIOLATIONS |
thresh_violations - Number of threshold
violations |
NUM_LW_THRESH_EXCEEDED |
num_lw_thresh_exceeded - Number of
lock wait thresholds exceeded |
TOTAL_ROUTINE_INVOCATIONS |
total_routine_invocations - Total routine
invocations |
INT_COMMITS |
int_commits - Internal commits |
INT_ROLLBACKS |
int_rollbacks - Internal rollbacks |
CAT_CACHE_INSERTS |
cat_cache_inserts - Catalog cache inserts |
PKG_CACHE_INSERTS |
pkg_cache_inserts - Package cache inserts |
ACT_RQSTS_TOTAL |
act_rqsts_total - Total activity requests |
TOTAL_DISP_RUN_QUEUE_TIME |
total_disp_run_queue_time - Total dispatcher
run queue time |
POOL_QUEUED_ASYNC_DATA_REQS |
pool_queued_async_data_reqs - Data
prefetch requests |
POOL_QUEUED_ASYNC_INDEX_REQS |
pool_queued_async_index_reqs - Index
prefetch requests |
POOL_QUEUED_ASYNC_XDA_REQS |
pool_queued_async_xda_reqs - XDA prefetch
requests |
POOL_QUEUED_ASYNC_TEMP_DATA_REQS |
pool_queued_async_temp_data_reqs -
Data prefetch requests for temporary table spaces |
POOL_QUEUED_ASYNC_TEMP_INDEX_REQS |
pool_queued_async_temp_index_reqs -
Index prefetch requests for temporary table spaces |
POOL_QUEUED_ASYNC_TEMP_XDA_REQS |
pool_queued_async_temp_xda_reqs - XDA
data prefetch requests for temporary table spaces |
POOL_QUEUED_ASYNC_OTHER_REQS |
pool_queued_async_other_reqs - Non-prefetch
requests |
POOL_QUEUED_ASYNC_DATA_PAGES |
pool_queued_async_data_pages - Data
pages prefetch requests |
POOL_QUEUED_ASYNC_INDEX_PAGES |
pool_queued_async_index_pages - Index
pages prefetch requests |
POOL_QUEUED_ASYNC_XDA_PAGES |
pool_queued_async_xda_pages - XDA pages
prefetch requests |
POOL_QUEUED_ASYNC_TEMP_DATA_PAGES |
pool_queued_async_temp_data_pages -
Data pages prefetch requests for temporary table spaces |
POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES |
pool_queued_async_temp_index_pages
- Index pages prefetch requests for temporary table spaces |
POOL_QUEUED_ASYNC_TEMP_XDA_PAGES |
pool_queued_async_temp_xda_pages -
XDA data pages prefetch requests for temporary table spaces |
POOL_FAILED_ASYNC_DATA_REQS |
pool_failed_async_data_reqs - Failed
data prefetch requests |
POOL_FAILED_ASYNC_INDEX_REQS |
pool_failed_async_index_reqs - Failed
index prefetch requests |
POOL_FAILED_ASYNC_XDA_REQS |
pool_failed_async_xda_reqs - Failed
XDA prefetch requests |
POOL_FAILED_ASYNC_TEMP_DATA_REQS |
pool_failed_async_temp_data_reqs -
Failed data prefetch requests for temporary table spaces |
POOL_FAILED_ASYNC_TEMP_INDEX_REQS |
pool_failed_async_temp_index_reqs -
Failed index prefetch requests for temporary table spaces |
POOL_FAILED_ASYNC_TEMP_XDA_REQS |
pool_failed_async_temp_xda_reqs - Failed
XDA prefetch requests for temporary table spaces |
POOL_FAILED_ASYNC_OTHER_REQS |
pool_failed_async_other_reqs - Failed
non-prefetch requests |
APP_ACT_COMPLETED_TOTAL |
app_act_completed_total - Total successful
external coordinator activities |
APP_ACT_ABORTED_TOTAL |
app_act_aborted_total - Total failed
external coordinator activities |
APP_ACT_REJECTED_TOTAL |
app_act_rejected_total - Total rejected
external coordinator activities |
TOTAL_PEDS |
total_peds - Total partial early distincts |
DISABLED_PEDS |
disabled_peds - Disabled partial early
distincts |
POST_THRESHOLD_PEDS |
post_threshold_peds - Partial early
distincts threshold |
TOTAL_PEAS |
total_peas - Total partial early aggregations |
POST_THRESHOLD_PEAS |
post_threshold_peas - Partial early
aggregation threshold |
TQ_SORT_HEAP_REQUESTS |
tq_sort_heap_requests - Table queue
sort heap requests |
TQ_SORT_HEAP_REJECTIONS |
tq_sort_heap_rejections - Table queue
sort heap rejections |
POOL_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP |
pool_data_gbp_indep_pages_found_in_lbp
- Group buffer pool independent data pages found in local buffer pool |
POOL_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP |
pool_index_gbp_indep_pages_found_in_lbp
- Group buffer pool independent index pages found in local buffer
pool |
POOL_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP |
pool_xda_gbp_indep_pages_found_in_lbp
- Group buffer pool XDA independent pages found in local buffer pool |
IDA_SEND_WAIT_TIME |
The total amount of time spent waiting to send
data to an in-database analytics process. |
IDA_SENDS_TOTAL |
The total number of times data was sent to an
in-database analytics process. |
IDA_SEND_VOLUME |
The total volume of data sent from the database
server to an in-database analytics process. The value is reported
in bytes. |
IDA_RECV_WAIT_TIME |
The total amount of time spent waiting to receive
data from an in-database analytics process. |
IDA_RECVS_TOTAL |
The total number of times data was received
from an in-database analytics process. |
IDA_RECV_VOLUME |
The total volume of data the database server
received from an in-database analytics process. The value is reported
in bytes. |