member |
xs:nonNegativeInteger |
member- Database member |
client_userid |
xs:string(255) |
CURRENT CLIENT_USERID special register |
client_wrkstnname |
xs:string(255) |
CURRENT CLIENT_WRKSTNNAME special register |
client_applname |
xs:string(255) |
CURRENT CLIENT_APPLNAME special register |
client_acctng |
xs:string(255) |
client_acctng - Client
accounting string monitor element |
application_handle |
xs:nonNegativeInteger |
application_handle - Application handle |
coord_member |
xs:nonNegativeInteger |
coord_member - Coordinator member |
uow_id |
xs:nonNegativeInteger |
uow_id - Unit of work ID |
activity_id |
xs:nonNegativeInteger |
activity_id - Activity ID |
parent_uow_id |
xs:nonNegativeInteger |
parent_uow_id - Parent unit of work
ID |
parent_activity_id |
xs:nonNegativeInteger |
parent_activity_id - Parent activity
ID |
activity_state |
xs:string |
activity_state - Activity state |
activity_type |
xs:string |
activity_type - Activity type |
nesting_level |
xs:nonNegativeInteger |
stmt_nest_level - Statement nesting
level |
invocation_id |
xs:nonNegativeInteger |
stmt_invocation_id - Statement invocation
identifier |
routine_id |
xs:nonNegativeInteger |
routine_id - Routine ID |
utility_id |
xs:nonNegativeInteger |
utility_id - Utility ID |
service_class_id |
xs:integer |
service_class_id - Service class |
database_work_action_set_id |
xs:nonNegativeInteger |
db_work_action_set_id - Database work
action set ID |
database_work_class_id |
xs:nonNegativeInteger |
db_work_class_id - Database work class
ID |
service_class_work_action_set_id |
xs:nonNegativeInteger |
sc_work_action_set_id - Service class
work action set ID |
service_class_work_class_id |
xs:nonNegativeInteger |
sc_work_class_id - Service class work
class ID |
entry_time |
xs:dateTime |
entry_time - Entry timeThe time that this activity
arrived into the system. |
local_start_time |
xs:dateTime |
local_start_time - Local start time. |
last_reference_time |
xs:dateTime |
last_reference_time - Last reference
time. Every time a request occurs in this activity, this field
is updated. |
package_name |
xs:string (128) |
package_name - Package name |
package_schema |
xs:string (128) |
package_schema - Package schema |
package_version_id |
xs:string (128) |
package_version_id - Package version |
section_number |
xs:integer |
section_number - Section number |
stmt_pkg_cache_id |
xs:nonNegativeInteger |
stmt_pkgcache_id - Statement package
cache identifier |
stmt_text |
xs:string |
stmt_text - SQL statement text. If the activity
is dynamic SQL or it is static SQL for which the statement text is
available, this field contains the first 1024 characters of the statement
text. Otherwise, it contains an empty string. |
effective_isolation |
xs:string |
effective_isolation - Effective isolation |
effective_lock_timeout |
xs:integer |
effective_lock_timeout - Effective
lock time-out |
effective_query_degree |
xs:integer |
effective_query_degree - Effective
query degree |
query_cost_estimate |
xs:integer |
query_cost_estimate - Query cost estimate |
qp_query_id |
xs:nonNegativeInteger |
qp_query_id - Query patroller query
ID |
concurrentdbcoordactivities_db
_threshold_id
|
xs:int |
concurrentdbcoordactivities_db_threshold_id
- Concurrent database coordinator activities threshold ID |
concurrentdbcoordactivities_db
_threshold_value
|
xs:long |
concurrentdbcoordactivities_db_threshold_value
- Concurrent database coordinator activities |
concurrentdbcoordactivities_db
_threshold_queued
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_db_threshold_queued
- Concurrent database coordinator activities |
concurrentdbcoordactivities_db
_threshold_violated
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_db_threshold_violated
- Concurrent database coordinator activities threshold violated |
concurrentdbcoordactivities
_superclass_threshold_id
|
xs:int |
concurrentdbcoordactivities_superclass_threshold_id
- Concurrent database coordinator activities superclass |
concurrentdbcoordactivities
_superclass_threshold_value
|
xs:long |
concurrentdbcoordactivities_superclass_threshold_value
- Concurrent database coordinator activities superclass threshold
value |
concurrentdbcoordactivities
_superclass_threshold_queued
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_superclass_threshold_queued
- Concurrent database coordinator activities superclass threshold
queued |
concurrentdbcoordactivities
_superclass_threshold_violated
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_superclass_threshold_violated
- Concurrent database coordinator activities superclass threshold
violated |
concurrentdbcoordactivities
_subclass_threshold_id
|
xs:int |
concurrentdbcoordactivities_subclass_threshold_id
- Concurrent database coordinator activities subclass threshold ID |
concurrentdbcoordactivities
_subclass_threshold_value
|
xs:long |
concurrentdbcoordactivities_subclass_threshold_value
- Concurrent database coordinator activities subclass threshold value |
concurrentdbcoordactivities
_subclass_threshold_queued
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_subclass_threshold_queued
- Concurrent database coordinator activities subclass threshold queued |
concurrentdbcoordactivities
_subclass_threshold_violated
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_subclass_threshold_violated
- Concurrent database coordinator activities subclass threshold violated |
concurrentdbcoordactivities
_work_action_set_threshold
_id
|
xs:int |
concurrentdbcoordactivities_work_action_set_threshold_id
- Concurrent database coordinator activities work action set threshold
ID |
concurrentdbcoordactivities
_work_action_set_threshold
_value
|
xs:long |
concurrentdbcoordactivities_work_action_set_threshold_value
- Concurrent database coordinator activities work action set threshold
value |
concurrentdbcoordactivities
_work_action_set_threshold
_queued
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_work_action_set_threshold_queued
- Concurrent database coordinator activities work action set threshold
queued |
concurrentdbcoordactivities
_work_action_set_threshold
_violated
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_work_action_set_threshold_violated
- Concurrent database coordinator activities work action set threshold
violated |
estimatedsqlcost_threshold_id |
xs:int |
estimatedsqlcost_threshold_id - Estimated
SQL cost threshold ID |
estimatedsqlcost_threshold
_value
|
xs:long |
estimatedsqlcost_threshold_value -
Estimated SQL cost threshold value |
estimatedsqlcost_threshold
_violated
|
xs:short (1 = yes, 0 = no) |
estimatedsqlcost_threshold_violated
- Estimated SQL cost threshold violated |
sqltempspace_threshold_id |
xs:int |
sqltempspace_threshold_id - SQL temporary
space threshold ID |
sqltempspace_threshold
_value
|
xs:long |
sqltempspace_threshold_value - SQL
temporary space threshold value |
sqltempspace_threshold
_violated
|
xs:short (1 = yes, 0 = no) |
sqltempspace_threshold_violated - SQL
temporary space threshold violated |
sqlrowsreturned_threshold_id |
xs:int |
sqlrowsreturned_threshold_id - SQL
rows read returned threshold ID |
sqlrowsreturned_threshold
_value
|
xs:long |
sqlrowsreturned_threshold_value - SQL
rows read returned threshold value |
sqlrowsreturned_threshold
_violated
|
xs:short (1 = yes, 0 = no) |
sqlrowsreturned_threshold_violated
- SQL rows read returned threshold violated |
activitytotaltime_threshold_id |
xs:int |
activitytotaltime_threshold_id - Activity
total time threshold ID |
activitytotaltime_threshold_value |
xs:dateTime |
activitytotaltime_threshold_value -
Activity total time threshold value |
activitytotaltime_threshold
_violated
|
xs:short (1 = yes, 0 = no) |
activitytotaltime_threshold_violated
- Activity total time threshold violated |
cputime_threshold_id |
xs:int |
cputime_threshold_id - CPU time threshold
ID |
cputime_threshold_value |
xs:long |
cputime_threshold_value - CPU time
threshold value |
cputime_threshold_violated |
xs:short (1 = yes, 0 = no) |
cputime_threshold_violated - CPU time
threshold violated |
cputimeinsc_threshold_id |
xs:int |
cputimeinsc_threshold_id - CPU time
in service threshold ID |
cputimeinsc_threshold_value |
xs:long |
cputimeinsc_threshold_value - CPU time
in service threshold value |
cputimeinsc_threshold
_violated
|
xs:short (1 = yes, 0 = no) |
cputimeinsc_threshold_violated - CPU
time in service threshold violated |
sqlrowsread_threshold_id |
xs:int |
sqlrowsread_threshold_ID - SQL rows
read threshold ID |
sqlrowsread_threshold_value |
xs:long |
sqlrowsread_threshold_value - SQL rows
read threshold value |
sqlrowsread_threshold_violated |
xs:short (1 = yes, 0 = no) |
sqlrowsread_threshold_violated - SQL
rows read threshold violated |
sqlrowsreadinsc_threshold_id |
xs:int |
sqlrowsreadinsc_threshold_id - SQL
rows read in service threshold ID |
sqlrowsreadinsc_threshold
_value
|
xs:long |
sqlrowsreadinsc_threshold_value - SQL
rows read in service threshold value |
sqlrowsreadinsc_threshold
_violated
|
xs:short (1 = yes, 0 = no) |
sqlrowsreadinsc_threshold_violated
- SQL rows read in service threshold violated |
aggsqltempspace_threshold_id |
xs:int |
aggsqltempspace_threshold_id - AggSQL
temporary space threshold ID. |
aggsqltempspace_threshold
_value
|
xs:long |
aggsqltempspace_threshold_value - AggSQL
temporary space threshold value |
aggsqltempspace_threshold
_violated
|
xs:short (1 = yes, 0 = no) |
aggsqltempspace_threshold_violated
- AggSQL temporary space threshold violated |
audit_events_total |
xs:nonNegativeInteger |
audit_events_total - Total audit events |
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 |
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 |
coord_stmt_exec_time |
|
coord_stmt_exec_time
- Execution time for statement by coordinator agent |
deadlocks |
xs:nonNegativeInteger |
deadlocks - Deadlocks detected |
diaglog_writes_total |
xs:nonNegativeInteger |
diaglog_writes_total - Diag log total
writes |
diaglog_write_wait_time |
xs:nonNegativeInteger |
diaglog_write_wait_time - Diag log
write time |
direct_read_time |
xs:nonNegativeInteger |
direct_read_time - Direct read time |
direct_write_time |
xs:nonNegativeInteger |
direct_write_time - Direct write time |
direct_read_reqs |
xs:nonNegativeInteger |
direct_read_reqs - Direct read requests |
direct_reads |
xs:nonNegativeInteger |
direct_reads - Direct reads from database |
direct_write_reqs |
xs:nonNegativeInteger |
direct_write_reqs - Direct write requests |
direct_writes |
xs:nonNegativeInteger |
direct_writes - Direct writes to database |
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_recvs_total |
xs:nonNegativeInteger |
fcm_recvs_total - FCM recvs total |
fcm_message_recv_volume |
xs:nonNegativeInteger |
fcm_message_recv_volume - FCM message
recv volume |
fcm_message_recvs_total |
xs:nonNegativeInteger |
fcm_message_recvs_total - FCM message
recvs total |
fcm_message_recv_wait_time |
xs:nonNegativeInteger |
fcm_message_recv_wait_time - FCM message
recv wait time |
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_sends_total |
xs:nonNegativeInteger |
fcm_message_sends_total - FCM message
sends 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_sends_total |
xs:nonNegativeInteger |
fcm_sends_total - FCM sends total |
fcm_tq_recv_wait_time |
xs:nonNegativeInteger |
fcm_tq_recv_wait_time - FCM tablequeue
recv wait time |
fcm_tq_send_wait_time |
xs:nonNegativeInteger |
fcm_tq_send_wait_time - FCM tablequeue
send wait time |
fcm_tq_recv_volume |
xs:nonNegativeInteger |
fcm_tq_recv_volume - FCM tablequeue
recv volume |
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_sends_total |
xs:nonNegativeInteger |
fcm_tq_sends_total - FCM tablequeue
send total |
tq_tot_send_spills |
xs:nonNegativeInteger |
tq_tot_send_spills - Total number of
tablequeue buffers overflowed |
lock_escals |
xs:nonNegativeInteger |
lock_escals - Number of lock escalations |
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 |
num_lw_thresh_exceeded |
xs:nonNegativeInteger |
num_lw_thresh_exceeded - Number of
thresholds exceeded
|
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_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_read_time |
xs:nonNegativeInteger |
pool_read_time - Total buffer pool
physical read time |
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_l_reads |
xs:nonNegativeInteger |
pool_xda_l_reads - Buffer pool XDA
data logical reads |
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 |
num_log_buffer_full |
xs:nonNegativeInteger |
num_log_buffer_full - Number of full
log buffers |
rows_modified |
xs:nonNegativeInteger |
rows_modified - Rows modified |
rows_read |
xs:nonNegativeInteger |
rows_read - Rows read |
rows_returned |
xs:nonNegativeInteger |
rows_returned - Rows returned |
stmt_exec_time |
xs:nonNegativeInteger |
stmt_exec_time
- Statement execution time |
thresh_violations |
xs:nonNegativeInteger |
thresh_violations
- Number of threshold violations |
total_cpu_time |
xs:nonNegativeInteger |
total_cpu_time - Total CPU time |
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_section_executions |
xs:nonNegativeInteger |
total_app_section_executions
- Total section executions |
total_routine_invocations |
xs:nonNegativeInteger |
total_routine_invocations
- Total routine invocations |
total_routine_non_
sect_proc_time
|
xs:nonNegativeInteger |
total_routine_non_sect_proc_time
- Non-section processing time |
total_routine_non_
sect_time
|
xs:nonNegativeInteger |
total_routine_non_sect_time
- Non-section routine execution time |
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_section_proc_time |
xs:nonNegativeInteger |
total_section_proc_time
- Total section processing time |
total_section_sort_time |
xs:nonNegativeInteger |
total_section_sort_time - Total section
sort time. |
total_section_sort_
proc_time
|
xs:nonNegativeInteger |
total_section_sort_proc_time - Total
section sort processing 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 |
post_threshold_sorts |
xs:nonNegativeInteger |
post_threshold_sorts - Post threshold
sorts |
post_shrthreshold_sorts |
xs:nonNegativeInteger |
post_shrthreshold_sorts - Post shared
threshold sorts |
sort_overflows |
xs:nonNegativeInteger |
sort_overflows - Sort overflows |
executable_id |
executable_id_type |
executable_id - Executable ID |
wlm_queue_time_total |
xs:nonNegativeInteger |
wlm_queue_time_total - Workload manager
total queue time |
wlm_queue_assignments_total |
xs:nonNegativeInteger |
wlm_queue_assignments_total - Workload
manager total queue assignments |
eff_stmt_text |
xs:string |
eff_stmt_text - Effective statement
text . The first 1024 characters of the concentrated statement
text following any literal replacement done by the statement concentrator.
Only present if the statement concentrator is enabled and this statement
was altered by the statement concentrator. |
wl_work_action_set_id |
xs:nonNegativeInteger |
wl_work_action_set_id - Workload work
action set identifier |
wl_work_class_id |
xs:nonNegativeInteger |
wl_work_class_id - Workload work class
identifier |
concurrentdbcoordactivities
_wl_was_threshold_id
|
xs:int |
concurrentdbcoordactivities_wl_was_threshold_id
- Concurrent database coordinator activities workload work action
set threshold ID |
concurrentdbcoordactivities
_wl_was_threshold_value
|
xs:long |
concurrentdbcoordactivities_wl_was_threshold_value
- Concurrent database coordinator activities workload work action
set threshold value |
concurrentdbcoordactivities
_wl_was_threshold_queued
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_wl_was_threshold_queued
- Concurrent database coordinator activities workload work action
set threshold queued |
concurrentdbcoordactivities
_wl_was_threshold_violated
|
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_wl_was_threshold_violated
- Concurrent database coordinator activities workload work action
set threshold violated |
ida_send_wait_time |
xs:nonNegativeInteger |
ida_send_wait_time - Time spent waiting
to send data |
ida_sends_total |
xs:nonNegativeInteger |
ida_sends_total - Number of times data
sent |
ida_send_volume |
xs:nonNegativeInteger |
ida_send_volume - Total data volume
sent |
ida_recv_volume |
xs:nonNegativeInteger |
ida_recv_volume - Total data volume
received |
ida_recv_wait_time |
xs:nonNegativeInteger |
ida_recv_wait_time - Time spent waiting
to receive data |
ida_recvs_total |
xs:nonNegativeInteger |
ida_recvs_total - Number of times data
received |