MEMBER |
SMALLINT |
member- Database member |
SECTION_TYPE |
CHAR(1) |
section_type - Section type indicator. |
INSERT_TIMESTAMP |
TIMESTAMP |
insert_timestamp - Statement insert
timestamp |
EXECUTABLE_ID |
VARCHAR(32) FOR BIT DATA |
executable_id - Executable ID. |
PACKAGE_SCHEMA |
VARCHAR(128) |
package_schema - Package schema . This output
is valid for static SQL statements only. A NULL value is returned
if the statement is dynamic. |
PACKAGE_NAME |
VARCHAR(128) |
package_name - Package name . This output is
valid for static SQL statements only. A NULL value is returned if
the statement is dynamic. |
PACKAGE_VERSION_ID |
VARCHAR(64) |
package_version_id - Package version. This
output is valid for static SQL statements only. A NULL value is returned
if the statement is dynamic or if you did not specify the package
version for static statement. An empty string will be returned for
static statement if the package version identifier was not specified
by you when the package was created. |
SECTION_NUMBER |
BIGINT |
section_number - Section number. A NULL value
is returned if the statement is dynamic. |
EFFECTIVE_ISOLATION |
CHAR(2) |
effective_isolation - Effective isolation. This
is the isolation value in effect for the section; it can be different
from what it was originally requested at compilation time. |
NUM_EXECUTIONS |
BIGINT |
num_executions - Statement executions |
NUM_EXEC_WITH_METRICS |
BIGINT |
num_exec_with_metrics - Number of executions
with metrics collected. |
PREP_TIME |
BIGINT |
prep_time - Preparation time Note that PREP_TIME
is only valid for dynamic SQL statements. PREP_TIME is reported as
0 for static SQL statements. |
FCM_TQ_RECV_WAITS_TOTAL |
BIGINT |
fcm_tq_recv_waits_total - Number of
times spent waiting to receive the next buffer monitor element |
FCM_MESSAGE_RECV_WAITS_TOTAL |
BIGINT |
fcm_message_recv_waits_total - Number
of times spent waiting for FCM reply message monitor element |
FCM_TQ_SEND_WAITS_TOTAL |
BIGINT |
fcm_tq_send_waits_total - Number of
times spent waiting to send the next buffer monitor element |
FCM_MESSAGE_SEND_WAITS_TOTAL |
BIGINT |
fcm_message_send_waits_total - Number
of times spent blocking on an FCM message send monitor element |
FCM_SEND_WAITS_TOTAL |
BIGINT |
fcm_send_waits_total - Number of times
spent blocking on an FCM send operation monitor element |
FCM_RECV_WAITS_TOTAL |
BIGINT |
fcm_recv_waits_total - Number of times
spent waiting to receive data through FCM monitor element |
TOTAL_ACT_TIME |
BIGINT |
total_act_time - Total activity time |
TOTAL_ACT_WAIT_TIME |
BIGINT |
total_act_wait_time - Total activity
wait time |
TOTAL_CPU_TIME |
BIGINT |
total_cpu_time - Total CPU time |
POOL_READ_TIME |
BIGINT |
pool_read_time - Total buffer pool
physical read time |
POOL_WRITE_TIME |
BIGINT |
pool_write_time - Total buffer pool
physical write time |
DIRECT_READ_TIME |
BIGINT |
direct_read_time - Direct Read Time |
DIRECT_WRITE_TIME |
BIGINT |
direct_write_time - Direct write time |
LOCK_WAIT_TIME |
BIGINT |
lock_wait_time - Time waited on locks |
TOTAL_SECTION_SORT_TIME |
BIGINT |
total_section_sort_time - Total section
sort time |
TOTAL_SECTION_SORT_PROC_TIME |
BIGINT |
total_section_sort_proc_time - Total
section sort processing time |
TOTAL_SECTION_SORTS |
BIGINT |
total_section_sorts - Total section
sorts |
LOCK_ESCALS |
BIGINT |
lock_escals - Number of lock escalations |
LOCK_WAITS |
BIGINT |
lock_waits - Lock waits |
ROWS_MODIFIED |
BIGINT |
rows_modified - Rows modified |
ROWS_READ |
BIGINT |
rows_read - Rows read |
ROWS_RETURNED |
BIGINT |
rows_returned - Rows returned |
DIRECT_READS |
BIGINT |
direct_reads - Direct reads from database |
DIRECT_READ_REQS |
BIGINT |
direct_read_reqs - Direct read requests |
DIRECT_WRITES |
BIGINT |
direct_writes - Direct writes to database |
DIRECT_WRITE_REQS |
BIGINT |
direct_write_reqs - Direct write requests |
POOL_DATA_L_READS |
BIGINT |
pool_data_l_reads - Buffer pool data
logical reads |
POOL_TEMP_DATA_L_READS |
BIGINT |
pool_temp_data_l_reads - Buffer pool
temporary data logical reads |
POOL_XDA_L_READS |
BIGINT |
pool_xda_l_reads - Buffer Pool XDA
Data Logical Reads |
POOL_TEMP_XDA_L_READS |
BIGINT |
pool_temp_xda_l_reads - Buffer pool
temporary XDA data logical reads |
POOL_INDEX_L_READS |
BIGINT |
pool_index_l_reads - Buffer pool index
logical reads |
POOL_TEMP_INDEX_L_READS |
BIGINT |
pool_temp_index_l_reads - Buffer pool
temporary index logical reads |
POOL_DATA_P_READS |
BIGINT |
pool_data_p_reads - Buffer pool data
physical reads |
POOL_TEMP_DATA_P_READS |
BIGINT |
pool_temp_data_p_reads - Buffer pool
temporary data physical reads |
POOL_XDA_P_READS |
BIGINT |
pool_xda_p_reads - Buffer pool XDA
data physical reads |
POOL_TEMP_XDA_P_READS |
BIGINT |
pool_temp_xda_p_reads - Buffer pool
temporary XDA data physical reads |
POOL_INDEX_P_READS |
BIGINT |
pool_index_p_reads - Buffer pool index
physical reads |
POOL_TEMP_INDEX_P_READS |
BIGINT |
pool_temp_index_p_reads - Buffer pool
temporary index physical reads |
POOL_DATA_WRITES |
BIGINT |
pool_data_writes - Buffer pool data
writes |
POOL_XDA_WRITES |
BIGINT |
pool_xda_writes - Buffer pool XDA data
writes |
POOL_INDEX_WRITES |
BIGINT |
pool_index_writes - Buffer pool index
writes |
TOTAL_SORTS |
BIGINT |
total_sorts - Total Sorts |
POST_THRESHOLD_SORTS |
BIGINT |
post_threshold_sorts - Post threshold
sorts |
POST_SHRTHRESHOLD_SORTS |
BIGINT |
post_shrthreshold_sorts - Post shared
threshold sorts |
SORT_OVERFLOWS |
BIGINT |
sort_overflows - Sort overflows |
WLM_QUEUE_TIME_TOTAL |
BIGINT |
wlm_queue_time_total - Workload manager
total queue time |
WLM_QUEUE_ASSIGNMENTS_TOTAL |
BIGINT |
wlm_queue_assignments_total - Workload
manager total queue assignments |
DEADLOCKS |
BIGINT |
deadlocks - Deadlocks detected |
FCM_RECV_VOLUME |
BIGINT |
fcm_recv_volume - FCM recv volume |
FCM_RECVS_TOTAL |
BIGINT |
fcm_recvs_total - FCM recvs total |
FCM_SEND_VOLUME |
BIGINT |
fcm_send_volume - FCM send volume |
FCM_SENDS_TOTAL |
BIGINT |
fcm_sends_total - FCM sends total |
FCM_RECV_WAIT_TIME |
BIGINT |
fcm_recv_wait_time - FCM recv wait
time |
FCM_SEND_WAIT_TIME |
BIGINT |
fcm_send_wait_time - FCM send wait
time |
LOCK_TIMEOUTS |
BIGINT |
lock_timeouts - Number of lock timeouts |
LOG_BUFFER_WAIT_TIME |
BIGINT |
log_buffer_wait_time - Log buffer wait
time |
NUM_LOG_BUFFER_FULL |
BIGINT |
num_log_buffer_full - Number of full
log buffers |
LOG_DISK_WAIT_TIME |
BIGINT |
log_disk_wait_time - Log disk wait
time |
LOG_DISK_WAITS_TOTAL |
BIGINT |
log_disk_waits_total - Log disk waits
total |
LAST_METRICS_UPDATE |
TIMESTAMP |
last_metrics_update - Metrics last
update timestamp |
NUM_COORD_EXEC |
BIGINT |
num_coord_exec - Number of executions
by coordinator agent |
NUM_COORD_EXEC_WITH_METRICS |
BIGINT |
num_coord_exec_with_metrics - Number
of executions by coordinator agent |
VALID |
CHAR(1) |
valid - Section validity indicator. |
TOTAL_ROUTINE_TIME |
BIGINT |
total_routine_time
- Total routine time |
TOTAL_ROUTINE_INVOCATIONS |
BIGINT |
total_routine_invocations
- Total routine invocations |
ROUTINE_ID |
BIGINT |
routine_id - Routine ID monitor element |
STMT_TYPE_ID |
VARCHAR(32) |
stmt_type_id - Statement
type identifier |
QUERY_COST_ESTIMATE |
BIGINT |
query_cost_estimate
- Query cost estimate |
STMT_PKG_CACHE_ID |
BIGINT |
stmt_pkgcache_id -
Statement package cache identifier |
COORD_STMT_EXEC_TIME |
BIGINT |
coord_stmt_exec_time
- Execution time for statement by coordinator agent |
STMT_EXEC_TIME |
BIGINT |
stmt_exec_time - Statement
execution time |
TOTAL_SECTION_TIME |
BIGINT |
total_section_time
- Total section time |
TOTAL_SECTION_PROC_TIME |
BIGINT |
total_section_proc_time
- Total section processing time |
TOTAL_ROUTINE_NON_SECT_TIME |
BIGINT |
total_routine_non_sect_time
- Non-section routine execution time |
TOTAL_ROUTINE_NON_SECT_PROC_TIME |
BIGINT |
total_routine_non_sect_proc_time
- Non-section processing time |
LOCK_WAITS_GLOBAL |
BIGINT |
lock_waits_global - Lock waits global |
LOCK_WAIT_TIME_GLOBAL |
BIGINT |
lock_wait_time_global - Lock wait time
global |
LOCK_TIMEOUTS_GLOBAL |
BIGINT |
lock_timeouts_global - Lock timeouts
global |
LOCK_ESCALS_MAXLOCKS |
BIGINT |
lock_escals_maxlocks - Number of maxlocks
lock escalations |
LOCK_ESCALS_LOCKLIST |
BIGINT |
lock_escals_locklist - Number of locklist
lock escalations |
LOCK_ESCALS_GLOBAL |
BIGINT |
lock_escals_global - Number of global
lock escalations |
RECLAIM_WAIT_TIME |
BIGINT |
reclaim_wait_time - Reclaim wait time |
SPACEMAPPAGE_RECLAIM_WAIT_TIME |
BIGINT |
spacemappage_reclaim_wait_time - Space
map page reclaim wait time |
CF_WAITS |
BIGINT |
cf_waits - Number of cluster caching facility waits |
CF_WAIT_TIME |
BIGINT |
cf_wait_time - cluster caching facility wait
time |
POOL_DATA_GBP_L_READS |
BIGINT |
pool_data_gbp_l_reads - Group buffer
pool data logical reads |
POOL_DATA_GBP_P_READS |
BIGINT |
pool_data_gbp_p_reads - Group buffer
pool data physical reads |
POOL_DATA_LBP_PAGES_FOUND |
BIGINT |
pool_data_lbp_pages_found - Local
buffer pool found data pages |
POOL_DATA_GBP_INVALID_PAGES |
BIGINT |
pool_data_gbp_invalid_pages - Group
buffer pool invalid data pages |
POOL_INDEX_GBP_L_READS |
BIGINT |
pool_index_gbp_l_reads - Group buffer
pool index logical reads |
POOL_INDEX_GBP_P_READS |
BIGINT |
pool_index_gbp_p_reads - Group buffer
pool index physical reads |
POOL_INDEX_LBP_PAGES_FOUND |
BIGINT |
pool_index_lbp_pages_found - Local
buffer pool index pages found |
POOL_INDEX_GBP_INVALID_PAGES |
BIGINT |
pool_index_gbp_invalid_pages - Group
buffer pool invalid index pages |
POOL_XDA_GBP_L_READS |
BIGINT |
pool_xda_gbp_l_reads - Group buffer
pool XDA data logical read requests |
POOL_XDA_GBP_P_READS |
BIGINT |
pool_xda_gbp_p_reads - Group buffer
pool XDA data physical read requests |
POOL_XDA_LBP_PAGES_FOUND |
BIGINT |
pool_xda_lbp_pages_found - Local buffer
pool XDA data pages found |
POOL_XDA_GBP_INVALID_PAGES |
BIGINT |
pool_xda_gbp_invalid_pages - Group
buffer pool invalid XDA data pages |
AUDIT_EVENTS_TOTAL |
BIGINT |
audit_events_total - Total audit events |
AUDIT_FILE_WRITES_TOTAL |
BIGINT |
audit_file_writes_total - Total Audit
files written |
AUDIT_FILE_WRITE_WAIT_TIME |
BIGINT |
audit_file_write_wait_time - Audit
file write wait time |
AUDIT_SUBSYSTEM_WAITS_TOTAL |
BIGINT |
audit_subsystem_waits_total - Total
audit subsystem waits |
AUDIT_SUBSYSTEM_WAIT_TIME |
BIGINT |
audit_subsystem_wait_time - Audit subsystem
wait time |
DIAGLOG_WRITES_TOTAL |
BIGINT |
diaglog_writes_total - Diag log total
writes |
DIAGLOG_WRITE_WAIT_TIME |
BIGINT |
diaglog_write_wait_time - Diag log
write time |
FCM_MESSAGE_RECVS_TOTAL |
BIGINT |
fcm_message_recvs_total - FCM message
recvs total |
FCM_MESSAGE_RECV_VOLUME |
BIGINT |
fcm_message_recv_volume - FCM message
recv volume |
FCM_MESSAGE_RECV_WAIT_TIME |
BIGINT |
fcm_message_recv_wait_time - FCM message
recv wait time |
FCM_MESSAGE_SENDS_TOTAL |
BIGINT |
fcm_message_sends_total - FCM message
sends total |
FCM_MESSAGE_SEND_VOLUME |
BIGINT |
fcm_message_send_volume - FCM message
send volume |
FCM_MESSAGE_SEND_WAIT_TIME |
BIGINT |
fcm_message_send_wait_time - FCM message
send wait time |
FCM_TQ_RECVS_TOTAL |
BIGINT |
fcm_tq_recvs_total - FCM tablequeue
recvs total |
FCM_TQ_RECV_VOLUME |
BIGINT |
fcm_tq_recv_volume - FCM tablequeue
recv volume |
FCM_TQ_RECV_WAIT_TIME |
BIGINT |
fcm_tq_recv_wait_time - FCM tablequeue
recv wait time |
FCM_TQ_SENDS_TOTAL |
BIGINT |
fcm_tq_sends_total - FCM tablequeue
send total |
FCM_TQ_SEND_VOLUME |
BIGINT |
fcm_tq_send_volume - FCM tablequeue
send volume |
FCM_TQ_SEND_WAIT_TIME |
BIGINT |
fcm_tq_send_wait_time - FCM tablequeue
send wait time |
NUM_LW_THRESH_EXCEEDED |
BIGINT |
num_lw_thresh_exceeded - Number of
thresholds exceeded |
THRESH_VIOLATIONS |
BIGINT |
thresh_violations - Number of threshold
violations |
TOTAL_APP_SECTION_EXECUTIONS |
BIGINT |
total_app_section_executions - Total
section executions |
TOTAL_ROUTINE_USER_CODE_PROC_TIME |
BIGINT |
total_routine_user_code_proc_time -
Total routine user code processing time |
TOTAL_ROUTINE_USER_CODE_TIME |
BIGINT |
total_routine_user_code_time - Total
routine user code time |
TQ_TOT_SEND_SPILLS |
BIGINT |
tq_tot_send_spills - Total number of
table queue buffers overflowed |
EVMON_WAIT_TIME |
BIGINT |
evmon_wait_time - Event monitor wait
time |
EVMON_WAITS_TOTAL |
BIGINT |
evmon_waits_total - Event monitor total
waits |
TOTAL_EXTENDED_LATCH_WAIT_TIME |
BIGINT |
total_extended_latch_wait_time - Total
extended latch wait time |
TOTAL_EXTENDED_LATCH_WAITS |
BIGINT |
total_extended_latch_waits - Total
extended latch waits |
MAX_COORD_STMT_EXEC_TIME |
BIGINT |
max_coord_stmt_exec_time - Maximum
coordinator statement execution time |
MAX_COORD_STMT_EXEC_TIMESTAMP |
TIMESTAMP |
max_coord_stmt_exec_timestamp - Maximum
coordinator statement execution timestamp monitor element |
TOTAL_DISP_RUN_QUEUE_TIME |
BIGINT |
total_disp_run_queue_time - Total dispatcher
run queue time |
QUERY_DATA_TAG_LIST |
VARCHAR(32) |
query_data_tag_list - Query data tag
list |
TOTAL_STATS_FABRICATION_TIME |
BIGINT |
total_stats_fabrication_time - Total
statistics fabrication time |
TOTAL_STATS_FABRICATIONS |
BIGINT |
total_stats_fabrications - Total statistics
fabrications |
TOTAL_SYNC_RUNSTATS_TIME |
BIGINT |
total_sync_runstats_time - Total synchronous
RUNSTATS time |
TOTAL_SYNC_RUNSTATS |
BIGINT |
total_sync_runstats - Total synchronous
RUNSTATS activities |
TOTAL_PEDS |
BIGINT |
total_peds - Total partial early distincts |
DISABLED_PEDS |
BIGINT |
disabled_peds - Disabled partial early
distincts |
POST_THRESHOLD_PEDS |
BIGINT |
post_threshold_peds - Partial early
distincts threshold |
TOTAL_PEAS |
BIGINT |
total_peas - Total partial early aggregations |
POST_THRESHOLD_PEAS |
BIGINT |
post_threshold_peas - Partial early
aggregation threshold |
TQ_SORT_HEAP_REQUESTS |
BIGINT |
tq_sort_heap_requests - Table queue
sort heap requests |
TQ_SORT_HEAP_REJECTIONS |
BIGINT |
tq_sort_heap_rejections - Table queue
sort heap rejections |
POOL_QUEUED_ASYNC_DATA_REQS |
BIGINT |
pool_queued_async_data_reqs - Data
prefetch requests monitor element |
POOL_QUEUED_ASYNC_INDEX_REQS |
BIGINT |
pool_queued_async_index_reqs - Index
prefetch requests monitor element |
POOL_QUEUED_ASYNC_XDA_REQS |
BIGINT |
pool_queued_async_xda_reqs - XDA prefetch
requests monitor element |
POOL_QUEUED_ASYNC_TEMP_DATA_REQS |
BIGINT |
pool_queued_async_temp_data_reqs -
Data prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_TEMP_INDEX_REQS |
BIGINT |
pool_queued_async_temp_index_reqs -
Index prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_TEMP_XDA_REQS |
BIGINT |
pool_queued_async_temp_xda_reqs - XDA
data prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_OTHER_REQS |
BIGINT |
pool_queued_async_other_reqs - Non-prefetch
requests monitor element |
POOL_QUEUED_ASYNC_DATA_PAGES |
BIGINT |
pool_queued_async_data_pages - Data
pages prefetch requests monitor element |
POOL_QUEUED_ASYNC_INDEX_PAGES |
BIGINT |
pool_queued_async_index_pages - Index
pages prefetch requests monitor element |
POOL_QUEUED_ASYNC_XDA_PAGES |
BIGINT |
pool_queued_async_xda_pages - XDA pages
prefetch requests monitor element |
POOL_QUEUED_ASYNC_TEMP_DATA_PAGES |
BIGINT |
pool_queued_async_temp_data_pages -
Data pages prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES |
BIGINT |
pool_queued_async_temp_index_pages
- Index pages prefetch requests for temporary table spaces monitor
element |
POOL_QUEUED_ASYNC_TEMP_XDA_PAGES |
BIGINT |
pool_queued_async_temp_xda_pages -
XDA data pages prefetch requests for temporary table spaces monitor
element |
POOL_FAILED_ASYNC_DATA_REQS |
BIGINT |
pool_failed_async_data_reqs - Failed
data prefetch requests monitor element |
POOL_FAILED_ASYNC_INDEX_REQS |
BIGINT |
pool_failed_async_index_reqs - Failed
index prefetch requests monitor element |
POOL_FAILED_ASYNC_XDA_REQS |
BIGINT |
pool_failed_async_xda_reqs - Failed
XDA prefetch requests monitor element |
POOL_FAILED_ASYNC_TEMP_DATA_REQS |
BIGINT |
pool_failed_async_temp_data_reqs -
Failed data prefetch requests for temporary table spaces monitor element |
POOL_FAILED_ASYNC_TEMP_INDEX_REQS |
BIGINT |
pool_failed_async_temp_index_reqs -
Failed index prefetch requests for temporary table spaces monitor
element |
POOL_FAILED_ASYNC_TEMP_XDA_REQS |
BIGINT |
pool_failed_async_temp_xda_reqs - Failed
XDA prefetch requests for temporary table spaces monitor element |
POOL_FAILED_ASYNC_OTHER_REQS |
BIGINT |
pool_failed_async_other_reqs - Failed
non-prefetch requests monitor element |
PREFETCH_WAIT_TIME |
BIGINT |
prefetch_wait_time - Time waited for
prefetch |
PREFETCH_WAITS |
BIGINT |
prefetch_waits - Prefetcher wait count
monitor element |
POOL_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_data_gbp_indep_pages_found_in_lbp
- Group buffer pool independent data pages found in local buffer pool
monitor element |
POOL_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_index_gbp_indep_pages_found_in_lbp
- Group buffer pool independent index pages found in local buffer
pool monitor element |
POOL_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_xda_gbp_indep_pages_found_in_lbp
- Group buffer pool XDA independent pages found in local buffer pool
monitor element |
NUM_WORKING_COPIES |
BIGINT |
Number of working copies. |
IDA_SEND_WAIT_TIME |
BIGINT |
The total amount of time spent waiting to send
data to an in-database analytics process. |
IDA_SENDS_TOTAL |
BIGINT |
The total number of times data was sent to an
in-database analytics process. |
IDA_SEND_VOLUME |
BIGINT |
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 |
BIGINT |
The total amount of time spent waiting to receive
data from an in-database analytics process. |
IDA_RECVS_TOTAL |
BIGINT |
The total number of times data was received
from an in-database analytics process. |
IDA_RECV_VOLUME |
BIGINT |
The total volume of data the database server
received from an in-database analytics process. The value is reported
in bytes. |
STMTNO |
INTEGER |
stmtno - Statement number monitor element |
NUM_ROUTINES |
INTEGER |
num_routines - Number of routines |
STMT_TEXT |
CLOB(2MB) |
stmt_text - SQL statement text |
COMP_ENV_DESC |
BLOB(10K) |
comp_env_desc - Compilation environment
handle. You can use the existing COMPILATION_ENV table function
to get the detailed compilation environment of the specific statement
if needed. |
MAX_COORD_STMT_EXEC_TIME_ARGS |
BLOB(10M) |
max_coord_stmt_exec_time_args - Maximum
coordinator statement execution time arguments |