act_aborted_total |
xs:nonNegativeInteger |
act_aborted_total - Total aborted activities
|
act_completed_total |
xs:nonNegativeInteger |
act_completed_total - Total completed activities
|
act_rejected_total |
xs:nonNegativeInteger |
act_rejected_total - Total rejected activities
|
act_rqsts_total |
xs:nonNegativeInteger |
act_rqsts_total - Total activity requests |
active_col_vector_consumers |
xs:long |
active_col_vector_consumers - Active columnar_vector consumers |
active_hash_grpbys |
xs:long |
active_hash_grpbys - Active hash GROUP BY operations |
active_hash_joins |
xs:long |
active_hash_joins - Active hash joins |
active_olap_funcs |
xs:long |
active_olap_funcs - Active OLAP Functions |
active_peas |
xs:long |
active_peas - Active partial early aggregations operations |
active_peds |
xs:long |
active_peds - Active partial early distinct operations |
active_sort_consumers |
xs:long |
active_sort_consumers - Active sort consumers |
active_sorts |
xs:long |
active_sorts - Active Sorts |
adm_bypass_act_total |
xs:long |
Reserved for future
use. |
adm_overflows |
xs:long |
Reserved for future
use. |
agent_id |
xs:nonNegativeInteger |
agent_id
- Application handle (agent ID) monitor element |
agent_wait_time |
xs:nonNegativeInteger |
agent_wait_time - Agent wait time
|
agent_waits_total |
xs:nonNegativeInteger |
agent_waits_total - Total agent waits
|
app_act_aborted_total |
xs:nonNegativeInteger |
app_act_aborted_total - Total failed external coordinator
activities |
app_act_completed_total |
xs:nonNegativeInteger |
app_act_completed_total - Total successful external coordinator
activities |
app_act_rejected_total |
xs:nonNegativeInteger |
app_act_rejected_total - Total rejected external coordinator
activities |
app_rqsts_completed_total |
xs:nonNegativeInteger |
app_rqsts_completed_total - Total application requests
completed
|
appl_section_inserts |
xs:nonNegativeInteger |
appl_section_inserts - Insert count for SQL workspace monitor element |
appl_section_lookups |
xs:nonNegativeInteger |
appl_section_lookups - SQL workspace access count monitor element |
application_handle |
xs:nonNegativeInteger |
application_handle - Application handle |
application_id |
xs:string |
appl_id - Application ID |
application_name |
xs:string |
appl_name - Application name |
associated_agents_top |
xs:long |
associated_agents_top - Maximum Number of Associated Agents monitor element
|
audit_events_total |
xs:nonNegativeInteger |
audit_events_total - Total audit events
|
audit_file_write_wait_time |
xs:nonNegativeInteger |
audit_file_write_wait_time - Audit file write wait time
|
audit_file_writes_total |
xs:nonNegativeInteger |
audit_file_writes_total - Total Audit files written
|
audit_subsystem_wait_time |
xs:nonNegativeInteger |
audit_subsystem_wait_time - Audit subsystem wait time
|
audit_subsystem_waits_total |
xs:nonNegativeInteger |
audit_subsystem_waits_total - Total audit subsystem waits
|
binds_precompiles |
xs:long |
binds_precompiles - Binds/Precompiles Attempted monitor element
|
call_sql_stmts |
xs:long |
call_sql_stmts - CALL SQL statements executed |
cat_cache_inserts |
xs:nonNegativeInteger |
cat_cache_inserts - Catalog cache inserts
|
cat_cache_lookups |
xs:nonNegativeInteger |
cat_cache_lookups - Catalog cache lookups
|
client_acctng |
xs:string (255) |
client_acctng - Client accounting
string
|
client_applname |
xs:string (255) |
client_applname - Client application
name
|
client_hostname |
xs:string |
client_hostname - Client hostname
|
client_idle_wait_time |
xs:nonNegativeInteger |
client_idle_wait_time - Client idle wait time
|
client_ipaddr |
xs:string |
client_ipaddr - Client IP address monitor element
|
client_pid |
xs:nonNegativeInteger |
client_pid - Client process ID
|
client_platform |
xs:string |
client_platform - Client platform
|
client_port_number |
xs:nonNegativeInteger |
client_port_number - Client port number
|
client_prdid |
xs:string |
client_prdid - Client product and version ID
|
client_protocol |
xs:string |
client_protocol - Client communication
protocol
|
client_userid |
xs:string (255) |
client_userid - Client user ID
|
client_wrkstnname |
xs:string (255) |
client_wrkstnname - Client workstation
name
|
col_synopsis_rows_inserted |
xs:nonNegativeInteger |
col_synopsis_rows_inserted - Column-organized synopsis table rows inserted monitor
element |
col_vector_consumer_overflows |
xs:long |
col_vector_consumer_overflows - Columnar vector consumer overflows monitor element. |
comm_exit_wait_time |
xs:nonNegativeInteger |
comm_exit_wait_time - Communication buffer exit wait time monitor
element
|
comm_exit_waits |
xs:nonNegativeInteger |
comm_exit_waits - Communication buffer exit number of waits monitor
element
|
connection_reusability_status |
xs:short |
connection_reusability_status - Connection reusability status monitor element |
connection_start_time |
xs:dateTime |
connection_start_time - Connection start time
|
coord_member |
xs:short |
coord_member - Coordinating member
|
current_isolation |
xs:string |
current_isolation - Current isolation level |
ddl_sql_stmts |
xs:long |
ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
|
deadlocks |
xs:nonNegativeInteger |
deadlocks - Deadlocks detected
|
diaglog_write_wait_time |
xs:nonNegativeInteger |
diaglog_write_wait_time - Diag log write time
|
diaglog_writes_total |
xs:nonNegativeInteger |
diaglog_writes_total - Diag log total writes
|
direct_read_reqs |
xs:nonNegativeInteger |
direct_read_reqs - Direct read requests
|
direct_read_time |
xs:nonNegativeInteger |
direct_read_time - Direct read time
|
direct_reads |
xs:nonNegativeInteger |
direct_reads - Direct reads from database
|
direct_write_reqs |
xs:nonNegativeInteger |
direct_write_reqs - Direct write requests
|
direct_write_time |
xs:nonNegativeInteger |
direct_write_time - Direct write time
|
direct_writes |
xs:nonNegativeInteger |
direct_writes - Direct writes to database
|
disabled_peds |
xs:long |
disabled_peds - Disabled partial early distincts
|
dynamic_sql_stmts |
xs:long |
dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
|
evmon_wait_time |
xs:nonNegativeInteger |
evmon_wait_time - Event monitor wait time
|
evmon_waits_total |
xs:nonNegativeInteger |
evmon_waits_total - Event monitor total waits
|
execution_id |
xs:string(128) |
execution_id - User Login ID monitor element |
ext_table_read_volume |
xs:nonNegativeInteger |
ext_table_read_volume - Total data read by external table readers monitor element |
ext_table_recv_volume |
xs:nonNegativeInteger |
ext_table_recv_volume - Total data received from external table readers monitor element |
ext_table_recv_wait_time |
xs:nonNegativeInteger |
ext_table_recv_wait_time - Total agent wait time for external table readers monitor
element |
ext_table_recvs_total |
xs:nonNegativeInteger |
ext_table_recvs_total - Total row batches received from external table readers monitor
element |
ext_table_send_volume |
xs:nonNegativeInteger |
ext_table_send_volume - Total data sent to external table writers monitor element |
ext_table_send_wait_time |
xs:nonNegativeInteger |
ext_table_send_wait_time - Total agent wait time for external table writers monitor
element |
ext_table_sends_total |
xs:nonNegativeInteger |
ext_table_sends_total - Total row batches sent to external table writers monitor element |
ext_table_write_volume |
xs:nonNegativeInteger |
ext_table_write_volume - Total data written by external table writers monitor element |
failed_sql_stmts |
xs:long |
failed_sql_stmts - Failed Statement Operations monitor element
|
fcm_message_recv_volume |
xs:nonNegativeInteger |
fcm_message_recv_volume - FCM message recv volume
|
fcm_message_recv_wait_time |
xs:nonNegativeInteger |
fcm_message_recv_wait_time - FCM message recv wait time
|
fcm_message_recv_waits_total |
xs:nonNegativeInteger |
fcm_message_recv_waits_total - Number of times spent waiting for FCM reply message monitor
element |
fcm_message_recvs_total |
xs:nonNegativeInteger |
fcm_message_recvs_total - FCM message recvs total
|
fcm_message_send_volume |
xs:nonNegativeInteger |
fcm_message_send_volume - FCM message send volume
|
fcm_message_send_wait_time |
xs:nonNegativeInteger |
fcm_message_send_wait_time - FCM message send wait time
|
fcm_message_send_waits_total |
xs:nonNegativeInteger |
fcm_message_send_waits_total - Number of times spent blocking on an FCM message send monitor
element |
fcm_message_sends_total |
xs:nonNegativeInteger |
fcm_message_sends_total - FCM message sends total
|
fcm_recv_volume |
xs:nonNegativeInteger |
fcm_recv_volume - FCM recv volume
|
fcm_recv_wait_time |
xs:nonNegativeInteger |
fcm_recv_wait_time - FCM recv wait time
|
fcm_recv_waits_total |
xs:nonNegativeInteger |
fcm_recv_waits_total - Number of times spent waiting to receive data through FCM monitor
element |
fcm_recvs_total |
xs:nonNegativeInteger |
fcm_recvs_total - FCM recvs total
|
fcm_send_volume |
xs:nonNegativeInteger |
fcm_send_volume - FCM send volume
|
fcm_send_wait_time |
xs:nonNegativeInteger |
fcm_send_wait_time - FCM send wait time
|
fcm_send_waits_total |
xs:nonNegativeInteger |
fcm_send_waits_total - Number of times spent blocking on an FCM send operation monitor
element |
fcm_sends_total |
xs:nonNegativeInteger |
fcm_sends_total - FCM sends total
|
fcm_tq_recv_volume |
xs:nonNegativeInteger |
fcm_tq_recv_volume - FCM tablequeue recv volume
|
fcm_tq_recv_wait_time |
xs:nonNegativeInteger |
fcm_tq_recv_wait_time - FCM tablequeue recv wait time
|
fcm_tq_recv_waits_total |
xs:nonNegativeInteger |
fcm_tq_recv_waits_total - Number of times spent waiting to receive the next buffer monitor
element |
fcm_tq_recvs_total |
xs:nonNegativeInteger |
fcm_tq_recvs_total - FCM tablequeue recvs total
|
fcm_tq_send_volume |
xs:nonNegativeInteger |
fcm_tq_send_volume - FCM tablequeue send volume
|
fcm_tq_send_wait_time |
xs:nonNegativeInteger |
fcm_tq_send_wait_time - FCM tablequeue send wait time
|
fcm_tq_send_waits_total |
xs:nonNegativeInteger |
fcm_tq_send_waits_total - Number of times spent waiting to send the next buffer monitor
element |
fcm_tq_sends_total |
xs:nonNegativeInteger |
fcm_tq_sends_total - FCM tablequeue send total
|
fed_rows_deleted |
xs:nonNegativeInteger |
fed_rows_deleted - Rows deleted by a federation system monitor element |
fed_rows_inserted |
xs:nonNegativeInteger |
fed_rows_inserted - Rows inserted by a federation system monitor element |
fed_rows_read |
xs:nonNegativeInteger |
fed_rows_read - Rows read by a federation system monitor element |
fed_rows_updated |
xs:nonNegativeInteger |
fed_rows_updated - Rows updated by a federation system monitor element |
fed_wait_time |
xs:nonNegativeInteger |
fed_wait_time - Time spent by a federation server monitor element |
fed_waits_total |
xs:nonNegativeInteger |
fed_waits_total - Total number of execution times for a federation server monitor element |
hash_grpby_overflows |
xs:long |
hash_grpby_overflows - Hash group by overflows |
hash_join_overflows |
xs:long |
hash_join_overflows - Hash Join Overflows monitor element
|
hash_join_small_overflows |
xs:long |
hash_join_small_overflows - Hash Join Small Overflows monitor element
|
ida_recv_volume |
xs:long |
ida_recv_volume - Total data volume received monitor element |
ida_recv_wait_time |
xs:long |
ida_recv_wait_time - Time spent waiting to receive data monitor element |
ida_recvs_total |
xs:long |
ida_recvs_total - Number of times data received monitor element |
ida_send_volume |
xs:long |
ida_send_volume - Total data volume sent monitor element |
ida_send_wait_time |
xs:long |
ida_send_wait_time - Time spent waiting to send data monitor element |
ida_sends_total |
xs:long |
ida_sends_total - Number of times data sent monitor element |
implicit_rebinds |
xs:long |
implicit_rebinds - number of implicit rebinds |
int_commits |
xs:nonNegativeInteger |
int_commits - Internal commits
|
int_rollbacks |
xs:nonNegativeInteger |
int_rollbacks - Internal rollbacks
|
int_rows_deleted |
xs:long |
int_rows_deleted - Internal Rows Deleted monitor element
|
int_rows_inserted |
xs:long |
int_rows_inserted - Internal Rows Inserted monitor element
|
int_rows_updated |
xs:long |
int_rows_updated - Internal Rows Updated monitor element
|
intra_parallel_state |
xs:string |
intra_parallel_state - Current state of intrapartition parallelism
monitor element
|
ipc_recv_volume |
xs:nonNegativeInteger |
ipc_recv_volume - Interprocess communication recv volume
|
ipc_recv_wait_time |
xs:nonNegativeInteger |
ipc_recv_wait_time - Interprocess communication recv wait time
|
ipc_recvs_total |
xs:nonNegativeInteger |
ipc_recvs_total - Interprocess communication recvs total
|
ipc_send_volume |
xs:nonNegativeInteger |
ipc_send_volume - Interprocess communication send volume
|
ipc_send_wait_time |
xs:nonNegativeInteger |
ipc_send_wait_time - Interprocess communication send wait time
|
ipc_sends_total |
xs:nonNegativeInteger |
ipc_sends_total - Interprocess communication send total
|
is_system_appl |
xs:short |
is_system_appl - Is System Application monitor element
|
last_executable_id |
xs:hexBinary(32) |
last_executable_id - Last executable identifier
|
last_request_type |
xs:string(32) |
last_request_type - Last request type
|
lob_prefetch_reqs |
xs:nonNegativeInteger |
lob_prefetch_reqs - LOB prefetcher request count monitor element |
lob_prefetch_wait_time |
xs:nonNegativeInteger |
lob_prefetch_wait_time - LOB prefetch wait time monitor element |
lock_escals |
xs:nonNegativeInteger |
lock_escals - Number of lock escalations
|
lock_timeout_val |
xs:long |
lock_timeout_val - Lock timeout value monitor element
|
lock_timeouts |
xs:nonNegativeInteger |
lock_timeouts - Number of lock timeouts
|
lock_wait_time |
xs:nonNegativeInteger |
lock_wait_time - Time waited on locks
|
lock_waits |
xs:nonNegativeInteger |
lock_waits - Lock waits
|
log_buffer_wait_time |
xs:nonNegativeInteger |
log_buffer_wait_time - Log buffer wait time
|
log_disk_wait_time |
xs:nonNegativeInteger |
log_disk_wait_time - Log disk wait time
|
log_disk_waits_total |
xs:nonNegativeInteger |
log_disk_waits_total - Log disk waits total
|
member |
xs:nonNegativeInteger |
member- Database member |
member_subset_id |
xs:long |
member_subset_id - Member subset ID |
merge_sql_stmts |
xs:long |
merge_sql_stmts - Merge SQL statements executed |
num_assoc_agents |
xs:long |
num_assoc_agents - Number of Associated Agents monitor element
|
num_locks_held |
xs:nonNegativeInteger |
locks_held - Locks held |
num_locks_waiting |
xs:long |
locks_waiting - Current agents waiting on locks monitor element |
num_log_buffer_full |
xs:nonNegativeInteger |
num_log_buffer_full - Number of full log buffers
|
num_lw_thresh_exceeded |
xs:nonNegativeInteger |
num_lw_thresh_exceeded - Number of thresholds exceeded |
olap_func_overflows |
xs:long |
olap_func_overflows - OLAP Function Overflows monitor element
|
pkg_cache_inserts |
xs:nonNegativeInteger |
pkg_cache_inserts - Package cache inserts
|
pkg_cache_lookups |
xs:nonNegativeInteger |
pkg_cache_lookups - Package cache lookups
|
pool_col_gbp_indep_pages_found_in_lbp |
xs:nonNegativeInteger |
pool_col_gbp_indep_pages_found_in_lbp - Buffer pool column-organized GBP independent pages found in
local buffer pool |
pool_col_gbp_invalid_pages |
xs:nonNegativeInteger |
pool_col_gbp_invalid_pages - Buffer pool column-organized GBP invalid data pages |
pool_col_gbp_l_reads |
xs:nonNegativeInteger |
pool_col_gbp_l_reads - Buffer pool column-organized GBP logical reads |
pool_col_gbp_p_reads |
xs:nonNegativeInteger |
pool_col_gbp_p_reads - Buffer pool column-organized GBP physical reads |
pool_col_l_reads |
xs:nonNegativeInteger |
pool_col_l_reads - Buffer pool column-organized logical reads |
pool_col_lbp_pages_found |
xs:nonNegativeInteger |
pool_col_lbp_pages_found - Buffer pool column-organized LBP pages found |
pool_col_p_reads |
xs:nonNegativeInteger |
pool_col_p_reads - Buffer pool column-organized physical reads |
pool_col_writes |
xs:nonNegativeInteger |
pool_col_writes - Buffer pool column-organized writes |
pool_data_gbp_indep_pages_found_in_lbp |
xs:nonNegativeInteger |
pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool
independent data pages found in local buffer pool monitor element
|
pool_data_l_reads |
xs:nonNegativeInteger |
pool_data_l_reads - Buffer pool data logical reads
|
pool_data_p_reads |
xs:nonNegativeInteger |
pool_data_p_reads - Buffer pool data physical reads
|
pool_data_writes |
xs:nonNegativeInteger |
pool_data_writes - Buffer pool data writes
|
pool_failed_async_col_reqs |
xs:nonNegativeInteger |
pool_failed_async_col_reqs - Failed column-organized prefetch requests |
pool_failed_async_data_reqs |
xs:nonNegativeInteger |
pool_failed_async_data_reqs - Failed data prefetch requests
|
pool_failed_async_index_reqs |
xs:nonNegativeInteger |
pool_failed_async_index_reqs - Failed index prefetch requests
|
pool_failed_async_temp_col_reqs |
xs:nonNegativeInteger |
pool_failed_async_temp_col_reqs - Failed column-organized temporary prefetch requests |
pool_failed_async_temp_data_reqs |
xs:nonNegativeInteger |
pool_failed_async_temp_data_reqs - Failed data prefetch requests for
temporary table spaces
|
pool_failed_async_temp_index_reqs |
xs:nonNegativeInteger |
pool_failed_async_temp_index_reqs - Failed index prefetch requests
for temporary table spaces
|
pool_failed_async_temp_xda_reqs |
xs:nonNegativeInteger |
pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for
temporary table spaces
|
pool_failed_async_other_reqs |
xs:nonNegativeInteger |
pool_failed_async_other_reqs - Failed non-prefetch requests
|
pool_failed_async_xda_reqs |
xs:nonNegativeInteger |
pool_failed_async_xda_reqs - Failed XDA prefetch requests
|
pool_index_gbp_indep_pages_found_in_lbp |
xs:nonNegativeInteger |
pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool
independent index pages found in local buffer pool monitor element
|
pool_index_l_reads |
xs:nonNegativeInteger |
pool_index_l_reads - Buffer pool index logical reads
|
pool_index_p_reads |
xs:nonNegativeInteger |
pool_index_p_reads - Buffer pool index physical reads
|
pool_index_writes |
xs:nonNegativeInteger |
pool_index_writes - Buffer pool index writes
|
pool_queued_async_col_reqs |
xs:nonNegativeInteger |
pool_queued_async_col_reqs - Column-organized prefetch requests |
pool_queued_async_data_pages |
xs:nonNegativeInteger |
pool_queued_async_data_pages - Data pages prefetch requests
|
pool_queued_async_data_reqs |
xs:nonNegativeInteger |
pool_queued_async_data_reqs - Data prefetch requests
|
pool_queued_async_index_reqs |
xs:nonNegativeInteger |
pool_queued_async_index_reqs - Index prefetch requests
|
pool_queued_async_index_pages |
xs:nonNegativeInteger |
pool_queued_async_index_pages - Index pages prefetch requests
|
pool_queued_async_col_pages |
xs:nonNegativeInteger |
pool_queued_async_col_pages - Column-organized page prefetch requests |
pool_queued_async_temp_col_pages |
xs:nonNegativeInteger |
pool_queued_async_temp_col_pages - Column-organized page temporary prefetch requests |
pool_queued_async_temp_col_reqs |
xs:nonNegativeInteger |
pool_queued_async_temp_col_reqs - Column-organized temporary prefetch requests |
pool_queued_async_temp_data_pages |
xs:nonNegativeInteger |
pool_queued_async_temp_data_pages - Data pages prefetch requests for
temporary table spaces
|
pool_queued_async_temp_data_reqs |
xs:nonNegativeInteger |
pool_queued_async_temp_data_reqs - Data prefetch requests for
temporary table spaces
|
pool_queued_async_temp_index_pages |
xs:nonNegativeInteger |
pool_queued_async_temp_index_pages - Index pages prefetch requests
for temporary table spaces
|
pool_queued_async_temp_index_reqs |
xs:nonNegativeInteger |
pool_queued_async_temp_index_reqs - Index prefetch requests for
temporary table spaces
|
pool_queued_async_temp_xda_pages |
xs:nonNegativeInteger |
pool_queued_async_temp_xda_pages - XDA data pages prefetch requests
for temporary table spaces
|
pool_queued_async_temp_xda_reqs |
xs:nonNegativeInteger |
pool_queued_async_temp_xda_reqs - XDA data prefetch requests for
temporary table spaces
|
pool_queued_async_other_reqs |
xs:nonNegativeInteger |
pool_queued_async_other_reqs - Non-prefetch requests
|
pool_queued_async_xda_reqs |
xs:nonNegativeInteger |
pool_queued_async_xda_reqs - XDA prefetch requests
|
pool_read_time |
xs:nonNegativeInteger |
pool_read_time - Total buffer pool physical read time
|
pool_temp_col_l_reads |
xs:nonNegativeInteger |
pool_temp_col_l_reads - Buffer pool column-organized temporary logical reads |
pool_temp_col_p_reads |
xs:nonNegativeInteger |
pool_temp_col_p_reads - Buffer pool column-organized temporary physical reads |
pool_temp_data_l_reads |
xs:nonNegativeInteger |
pool_temp_data_l_reads - Buffer pool temporary data logical
reads
|
pool_temp_data_p_reads |
xs:nonNegativeInteger |
pool_temp_data_p_reads - Buffer pool temporary data physical
reads
|
pool_temp_index_l_reads |
xs:nonNegativeInteger |
pool_temp_index_l_reads - Buffer pool temporary index logical
reads
|
pool_temp_index_p_reads |
xs:nonNegativeInteger |
pool_temp_index_p_reads - Buffer pool temporary index physical
reads
|
pool_temp_xda_l_reads |
xs:nonNegativeInteger |
pool_temp_xda_l_reads - Buffer pool temporary XDA data logical
reads
|
pool_temp_xda_p_reads |
xs:nonNegativeInteger |
pool_temp_xda_p_reads - Buffer pool temporary XDA data physical
reads
|
pool_write_time |
xs:nonNegativeInteger |
pool_write_time - Total buffer pool physical write time
|
pool_xda_gbp_indep_pages_found_in_lbp |
xs:nonNegativeInteger |
pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA
independent pages found in local buffer pool monitor element
|
pool_xda_gbp_invalid_pages |
xs:nonNegativeInteger |
pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data
pages
|
pool_xda_gbp_l_reads |
xs:nonNegativeInteger |
pool_xda_gbp_l_reads - Group buffer pool XDA data logical read
requests
|
pool_xda_gbp_p_reads |
xs:nonNegativeInteger |
pool_xda_gbp_p_reads - Group buffer pool XDA data physical read
requests
|
pool_xda_l_reads |
xs:nonNegativeInteger |
pool_xda_l_reads - Buffer pool XDA data logical reads
|
pool_xda_lbp_pages_found |
xs:nonNegativeInteger |
pool_xda_lbp_pages_found - Local buffer pool XDA data pages
found
|
pool_xda_p_reads |
xs:nonNegativeInteger |
pool_xda_p_reads - Buffer pool XDA data physical reads
|
pool_xda_writes |
xs:nonNegativeInteger |
pool_xda_writes - Buffer pool XDA data writes
|
post_shrthreshold_hash_joins |
xs:long |
post_shrthreshold_hash_joins - Post threshold hash joins monitor element
|
post_shrthreshold_sorts |
xs:nonNegativeInteger |
post_shrthreshold_sorts - Post shared threshold sorts
|
post_threshold_col_vector_consumers |
xs:long |
post_threshold_col_vector_consumers - Post threshold columnar_vector consumers |
post_threshold_hash_grpbys |
xs:long |
post_threshold_hash_grpbys - Hash group by threshold |
post_threshold_hash_joins |
xs:long |
post_threshold_hash_joins - Hash Join Threshold monitor
element
|
post_threshold_olap_funcs |
xs:long |
post_threshold_olap_funcs - OLAP function threshold monitor element |
post_threshold_peas |
xs:long |
post_threshold_peas - Partial early aggregation threshold
|
post_threshold_peds |
xs:long |
post_threshold_peds - Partial early distincts threshold
|
post_threshold_sorts |
xs:nonNegativeInteger |
post_threshold_sorts - Post threshold sorts
|
prefetch_wait_time |
xs:nonNegativeInteger |
prefetch_wait_time - Time waited for prefetch |
prefetch_waits |
xs:nonNegativeInteger |
prefetch_waits - Prefetcher wait count |
prev_uow_stop_time |
xs:dateTime |
prev_uow_stop_time - Previous Unit of Work Completion Timestamp monitor element
|
reusability_status_reason |
xs:string (255) |
reusability_status_reason - Reusability status reason monitor element |
rows_deleted |
xs:long |
rows_deleted - Rows deleted monitor element
|
rows_inserted |
xs:long |
rows_inserted - Rows inserted monitor element
|
rows_modified |
xs:nonNegativeInteger |
rows_modified - Rows modified
|
rows_read |
xs:nonNegativeInteger |
rows_read - Rows read
|
rows_returned |
xs:nonNegativeInteger |
rows_returned - Rows returned
|
rows_updated |
xs:long |
rows_updated - Rows updated monitor element
|
rqsts_completed_total |
xs:nonNegativeInteger |
rqsts_completed_total - Total requests completed
|
select_sql_stmts |
xs:long |
select_sql_stmts - Select SQL Statements Executed monitor element
|
session_auth_id |
xs:string |
session_auth_id - Session authorization ID
|
sort_heap_allocated |
xs:long |
sort_heap_allocated - Total Sort Heap Allocated |
sort_overflows |
xs:nonNegativeInteger |
sort_overflows - Sort overflows
|
sort_shrheap_allocated |
xs:long |
sort_shrheap_allocated - Sort Share Heap Currently Allocated |
spacemappage_reclaim_wait_time |
xs:long |
spacemappage_reclaim_wait_time - Space map page reclaim wait time |
spacemappage_reclaim_wait_time |
xs:long |
spacemappage_reclaim_wait_time - Space map page reclaim wait time |
sql_reqs_since_commit |
xs:long |
sql_reqs_since_commit - SQL Requests Since Last Commit monitor element
|
static_sql_stmts |
xs:long |
static_sql_stmts - Static SQL Statements Attempted monitor element
|
system_auth_id |
xs:string |
system_auth_id - System authorization identifier
|
tcpip_recv_volume |
xs:nonNegativeInteger |
tcpip_recv_volume - TCP/IP received volume
|
tcpip_recv_wait_time |
xs:nonNegativeInteger |
tcpip_recv_wait_time - TCP/IP recv wait time
|
tcpip_recvs_total |
xs:nonNegativeInteger |
tcpip_recvs_total - TCP/IP recvs total
|
tcpip_send_volume |
xs:nonNegativeInteger |
tcpip_send_volume - TCP/IP send volume
|
tcpip_send_wait_time |
xs:nonNegativeInteger |
tcpip_send_wait_time - TCP/IP send wait time
|
tcpip_sends_total |
xs:nonNegativeInteger |
tcpip_sends_total - TCP/IP sends total
|
thresh_violations |
xs:nonNegativeInteger |
thresh_violations - Number of threshold violations |
total_act_time |
xs:nonNegativeInteger |
total_act_time - Total activity time
|
total_act_wait_time |
xs:nonNegativeInteger |
total_act_wait_time - Total activity wait time
|
total_app_commits |
xs:nonNegativeInteger |
total_app_commits - Total application commits
|
total_app_rollbacks |
xs:nonNegativeInteger |
total_app_rollbacks - Total application rollbacks
|
total_app_rqst_time |
xs:nonNegativeInteger |
total_app_rqst_time - Total application request time
|
total_app_section_executions |
xs:nonNegativeInteger |
total_app_section_executions - Total section
executions
|
total_backup_proc_time |
xs:long |
total_backup_proc_time - Total non-wait time for online backups |
total_backup_time |
xs:long |
total_backup_time - Total elapsed time for online backups |
total_backups |
xs:long |
total_backups - Total backups |
total_col_executions |
xs:nonNegativeInteger |
total_col_executions - Total column-organized executions |
total_col_proc_time |
xs:nonNegativeInteger |
total_col_proc_time - Total column-organized processing time |
total_col_synopsis_executions |
xs:nonNegativeInteger |
total_col_synopsis_executions - Total column-organized synopsis table executions monitor
element |
total_col_synopsis_proc_time |
xs:nonNegativeInteger |
total_col_synopsis_proc_time - Total column-organized synopsis table processing time monitor
element |
total_col_synopsis_time |
xs:nonNegativeInteger |
total_col_synopsis_time - Total column-organized synopsis table time monitor element |
total_col_time |
xs:nonNegativeInteger |
total_col_time - Total column-organized time |
total_col_vector_consumers |
xs:long |
total_col_vector_consumers - Total columnar_vector consumers |
total_commit_proc_time |
xs:nonNegativeInteger |
total_commit_proc_time - Total commits processing time
|
total_commit_time |
xs:nonNegativeInteger |
total_commit_time - Total commit time
|
total_compilations |
xs:nonNegativeInteger |
total_compilations - Total compilations
|
total_compile_proc_time |
xs:nonNegativeInteger |
total_compile_proc_time - Total compile processing time
|
total_compile_time |
xs:nonNegativeInteger |
total_compile_time - Total compile time
|
total_connect_authentication_time |
xs:nonNegativeInteger |
total_connect_authentication_time - Total connection or switch user
authentication request time monitor element |
total_connect_authentication_proc_time |
xs:nonNegativeInteger |
total_connect_authentication_proc_time - Total connection
authentication processing time monitor element |
total_connect_authentications |
xs:nonNegativeInteger |
total_connect_authentications - Connections or switch user
authentications performed
|
total_connect_request_proc_time |
xs:nonNegativeInteger |
total_connect_request_proc_time - Total connection or switch user
request processing time monitor element |
total_connect_request_time |
xs:nonNegativeInteger |
total_connect_request_time - Total connection or switch user request
time monitor element |
total_connect_requests |
xs:nonNegativeInteger |
total_connect_requests - Connection or switch user requests
|
total_cpu_time |
xs:nonNegativeInteger |
total_cpu_time - Total CPU time
|
total_disp_run_queue_time |
xs:long |
total_disp_run_queue_time - Total dispatcher run queue time |
total_extended_latch_wait_time |
xs:nonNegativeInteger |
total_extended_latch_wait_time - Total extended latch wait
time
|
total_extended_latch_waits |
xs:nonNegativeInteger |
total_extended_latch_waits - Total extended latch waits
|
total_hash_grpbys |
xs:long |
total_hash_grpbys - Total hash group by operations |
total_hash_joins |
xs:long |
total_hash_joins - Total Hash Joins monitor element
|
total_hash_loops |
xs:long |
total_hash_loops - Total Hash Loops monitor element
|
total_implicit_compilations |
xs:nonNegativeInteger |
total_implicit_compilations - Total implicit complications
|
total_implicit_compile_proc_time |
xs:nonNegativeInteger |
total_implicit_compile_proc_time - Total implicit compile processing
time
|
total_implicit_compile_time |
xs:nonNegativeInteger |
total_implicit_compile_time - Total implicit compile time
|
total_index_build_proc_time |
xs:long |
total_index_build_proc_time - Total non-wait time spent building indexes due to index creation,
recreation or rebuilding |
total_index_build_time |
xs:long |
total_index_build_time - Total time spent building indexes due to index creation, recreation or
rebuilding |
total_indexes_built |
xs:long |
total_indexes_built - Total number of indexes built |
total_load_proc_time |
xs:nonNegativeInteger |
total_load_proc_time - Total load processing time
|
total_load_time |
xs:nonNegativeInteger |
total_load_time - Total load time
|
total_loads |
xs:nonNegativeInteger |
total_loads - Total loads
|
total_olap_funcs |
xs:long |
total_olap_funcs - Total OLAP Functions monitor element
|
total_peas |
xs:long |
total_peas - Total partial early aggregations
|
total_peds |
xs:long |
total_peds - Total partial early distincts
|
total_reorg_proc_time |
xs:nonNegativeInteger |
total_reorg_proc_time - Total reorganization processing time
|
total_reorg_time |
xs:nonNegativeInteger |
total_reorg_time - Total reorganization time
|
total_reorgs |
xs:nonNegativeInteger |
total_reorgs - Total reorganizations
|
total_rollback_proc_time |
xs:nonNegativeInteger |
total_rollback_proc_time - Total rollback processing time
|
total_rollback_time |
xs:nonNegativeInteger |
total_rollback_time - Total rollback time
|
total_routine_invocations |
xs:nonNegativeInteger |
total_routine_invocations - Total routine
invocations
|
total_routine_time |
xs:nonNegativeInteger |
total_routine_time - Total routine time
|
total_routine_user_code_proc_time |
xs:nonNegativeInteger |
total_routine_user_code_proc_time - Total routine
user code processing time
|
total_routine_user_code_time |
xs:nonNegativeInteger |
total_routine_user_code_time - Total routine user
code time
|
total_rqst_time |
xs:nonNegativeInteger |
total_rqst_time - Total request time
|
total_runstats |
xs:nonNegativeInteger |
total_runstats - Total runtime statistics
|
total_runstats_proc_time |
xs:nonNegativeInteger |
total_runstats_proc_time - Total runtime statistics
processing time
|
total_runstats_time |
xs:nonNegativeInteger |
total_runstats_time - Total runtime statistics
|
total_section_proc_time |
xs:nonNegativeInteger |
total_section_proc_time - Total section processing
time
|
total_section_sort_proc_time |
xs:nonNegativeInteger |
total_section_sort_proc_time - Total section sort processing time |
total_section_sort_time |
xs:nonNegativeInteger |
total_section_sort_time - Total section sort time |
total_section_sorts |
xs:nonNegativeInteger |
total_section_sorts - Total section sorts |
total_section_time |
xs:nonNegativeInteger |
total_section_time - Total section time
|
total_sorts |
xs:nonNegativeInteger |
total_sorts - Total Sorts
|
total_stats_fabrication_proc_time |
xs:nonNegativeInteger |
total_stats_fabrication_proc_time - Total statistics fabrication
processing time |
total_stats_fabrication_time |
xs:nonNegativeInteger |
total_stats_fabrication_time - Total statistics fabrication
time |
total_stats_fabrications |
xs:nonNegativeInteger |
total_stats_fabrications - Total statistics fabrications |
total_sync_runstats |
xs:nonNegativeInteger |
total_sync_runstats - Total synchronous RUNSTATS activities |
total_sync_runstats_proc_time |
xs:nonNegativeInteger |
total_sync_runstats_proc_time - Total synchronous RUNSTATS processing
time |
total_sync_runstats_time |
xs:nonNegativeInteger |
total_sync_runstats_time - Total synchronous RUNSTATS time |
total_wait_time |
xs:nonNegativeInteger |
total_wait_time - Total wait time
|
tq_sort_heap_rejections |
xs:long |
tq_sort_heap_rejections - Table queue sort heap rejections
|
tq_sort_heap_requests |
xs:long |
tq_sort_heap_requests - Table queue sort heap requests
|
tq_tot_send_spills |
xs:nonNegativeInteger |
tq_tot_send_spills - Total number of table queue buffers overflowed
|
uid_sql_stmts |
xs:long |
uid_sql_stmts - Update/Insert/Delete SQL Statements Executed monitor element
|
uow_client_idle_wait_time |
xs:long |
uow_client_idle_wait_time - Client idle time within a unit of work |
uow_comp_status |
xs:string |
uow_comp_status - Unit of Work Completion Status monitor element
|
uow_start_time |
xs:dateTime |
uow_start_time - Unit of work start timestamp monitor element
|
uow_stop_time |
xs:dateTime |
uow_stop_time - Unit of work stop timestamp monitor element
|
wlm_queue_assignments_total |
xs:nonNegativeInteger |
wlm_queue_assignments_total - Workload manager total queue
assignments
|
wlm_queue_time_total |
xs:nonNegativeInteger |
wlm_queue_time_total - Workload manager total queue time
|
workload_occurrence_state |
xs:string |
workload_occurrence_state - Workload occurrence state monitor element
|
xquery_stmts |
xs:long |
xquery_stmts - XQuery Statements Attempted monitor element
|