activity_id |
xs:nonNegativeInteger |
activity_id - Activity ID |
activity_state |
xs:string |
activity_state - Activity state |
activity_type |
xs:string |
activity_type - Activity type |
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 |
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 |
application_handle |
xs:nonNegativeInteger |
application_handle - Application handle |
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 |
client_acctng |
xs:string(255) |
CURRENT CLIENT_ACCTNG special register |
client_applname |
xs:string(255) |
CURRENT CLIENT_APPLNAME special register |
client_userid |
xs:string(255) |
CURRENT CLIENT_USERID special register |
client_wrkstnname |
xs:string(255) |
CURRENT CLIENT_WRKSTNNAME special register |
concurrentdbcoordactivities_db_threshold_id |
xs:int |
concurrentdbcoordactivities_db_threshold_id
- Concurrent database coordinator activities threshold ID |
concurrentdbcoordactivities_db_threshold_queued |
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_db_threshold_queued
- Concurrent database coordinator activities |
concurrentdbcoordactivities_db_threshold_value |
xs:long |
concurrentdbcoordactivities_db_threshold_value
- 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_subclass_threshold_id |
xs:int |
concurrentdbcoordactivities_subclass_threshold_id
- Concurrent database coordinator activities subclass threshold ID |
concurrentdbcoordactivities_subclass_threshold_queued |
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_subclass_threshold_queued
- Concurrent database coordinator activities subclass threshold queued |
concurrentdbcoordactivities_subclass_threshold_value |
xs:long |
concurrentdbcoordactivities_subclass_threshold_value
- Concurrent database coordinator activities subclass threshold value |
concurrentdbcoordactivities_subclass_threshold_violated |
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_subclass_threshold_violated
- Concurrent database coordinator activities subclass threshold violated |
concurrentdbcoordactivities_superclass_threshold_id |
xs:int |
concurrentdbcoordactivities_superclass_threshold_id
- Concurrent database coordinator activities superclass |
concurrentdbcoordactivities_superclass_threshold_queued |
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_superclass_threshold_queued
- Concurrent database coordinator activities superclass threshold
queued |
concurrentdbcoordactivities_superclass_threshold_value |
xs:long |
concurrentdbcoordactivities_superclass_threshold_value
- Concurrent database coordinator activities superclass threshold
value |
concurrentdbcoordactivities_superclass_threshold_violated |
xs:short (1 = yes, 0 = no) |
concurrentdbcoordactivities_superclass_threshold_violated
- Concurrent database coordinator activities superclass threshold
violated |
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_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_value |
xs:long |
concurrentdbcoordactivities_wl_was_threshold_value
- Concurrent database coordinator activities workload work action
set threshold value |
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 |
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_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_value |
xs:long |
concurrentdbcoordactivities_work_action_set_threshold_value
- Concurrent database coordinator activities work action set threshold
value |
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 |
coord_member |
xs:nonNegativeInteger |
coord_member - Coordinator member |
coord_stmt_exec_time |
|
coord_stmt_exec_time
- Execution time for statement by coordinator agent |
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 |
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 |
datataginsc_threshold_id |
xs:int |
datataginsc_threshold_id - Datataginsc
in threshold identifier |
datataginsc_threshold_value |
xs:string(32) |
datataginsc_threshold_value - Datataginsc
in threshold value |
datataginsc_threshold_violated |
xs:short (1 = yes, 0 = no) |
datataginsc_threshold_violated - Datataginsc
in threshold violated |
datatagnotinsc_threshold_id |
xs:int |
datatagnotinsc_threshold_id - Datatagnotinsc
not in threshold identifier |
datatagnotinsc_threshold_value |
xs:string(32) |
datatagnotinsc_threshold_value - Datatagnotinsc
not in threshold value |
datatagnotinsc_threshold_violated |
xs:short (1 = yes, 0 = no) |
datatagnotinsc_threshold_violated -
Datatagnotinsc not in threshold violated |
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 monitor element |
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. |
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 |
entry_time |
xs:dateTime |
entry_time - Entry timeThe time that this activity
arrived into the system. |
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 |
evmon_wait_time |
xs:nonNegativeInteger |
evmon_wait_time - Event monitor wait
time |
evmon_waits_total |
xs:nonNegativeInteger |
evmon_waits_total - Event monitor total
waits |
executable_id |
executable_id_type |
executable_id - Executable ID |
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 |
ida_recv_wait_time |
xs:nonNegativeInteger |
The total amount of time spent waiting to receive
data from an in-database analytics process. |
ida_recv_volume |
xs:nonNegativeInteger |
The total volume of data the database server
received from an in-database analytics process. The value is reported
in bytes. |
ida_recvs_total |
xs:nonNegativeInteger |
The total number of times data was received
from an in-database analytics process. |
ida_send_wait_time |
xs:nonNegativeInteger |
The total amount of time spent waiting to send
data to an in-database analytics process. |
ida_send_volume |
xs:nonNegativeInteger |
The total volume of data sent from the database
server to an in-database analytics process. The value is reported
in bytes. |
ida_sends_total |
xs:nonNegativeInteger |
The total number of times data was sent to an
in-database analytics process. |
intra_parallel_state |
xs:string |
intra_parallel_state - Current state
of intrapartition parallelism monitor element |
invocation_id |
xs:nonNegativeInteger |
stmt_invocation_id - Statement invocation
identifier |
last_reference_time |
xs:dateTime |
last_reference_time - Last reference
time. Every time a request occurs in this activity, this field
is updated. |
local_start_time |
xs:dateTime |
local_start_time - Local start time. |
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 |
member |
xs:nonNegativeInteger |
member- Database member |
nesting_level |
xs:nonNegativeInteger |
stmt_nest_level - Statement nesting
level |
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
|
num_routines |
xs:int |
num_routines - Number of routines |
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 |
parent_activity_id |
xs:nonNegativeInteger |
parent_activity_id - Parent activity
ID |
parent_uow_id |
xs:nonNegativeInteger |
parent_uow_id - Parent unit of work
ID |
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_data_reqs |
xs:nonNegativeInteger |
pool_failed_async_data_reqs - Failed
data prefetch requests monitor element |
pool_failed_async_index_reqs |
xs:nonNegativeInteger |
pool_failed_async_index_reqs - Failed
index prefetch requests monitor element |
pool_failed_async_other_reqs |
xs:nonNegativeInteger |
pool_failed_async_other_reqs - Failed
non-prefetch requests monitor element |
pool_failed_async_temp_data_reqs |
xs:nonNegativeInteger |
pool_failed_async_temp_data_reqs -
Failed data prefetch requests for temporary table spaces monitor element |
pool_failed_async_temp_index_reqs |
xs:nonNegativeInteger |
pool_failed_async_temp_index_reqs -
Failed index prefetch requests for temporary table spaces monitor
element |
pool_failed_async_temp_xda_reqs |
xs:nonNegativeInteger |
pool_failed_async_temp_xda_reqs - Failed
XDA prefetch requests for temporary table spaces monitor element |
pool_failed_async_xda_reqs |
xs:nonNegativeInteger |
pool_failed_async_xda_reqs - Failed
XDA prefetch requests monitor element |
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_data_pages |
xs:nonNegativeInteger |
pool_queued_async_data_pages - Data
pages prefetch requests monitor element |
pool_queued_async_data_reqs |
xs:nonNegativeInteger |
pool_queued_async_data_reqs - Data
prefetch requests monitor element |
pool_queued_async_index_pages |
xs:nonNegativeInteger |
pool_queued_async_index_pages - Index
pages prefetch requests monitor element |
pool_queued_async_index_reqs |
xs:nonNegativeInteger |
pool_queued_async_index_reqs - Index
prefetch requests monitor element |
pool_queued_async_other_reqs |
xs:nonNegativeInteger |
pool_queued_async_other_reqs - Non-prefetch
requests monitor element |
pool_queued_async_temp_data_pages |
xs:nonNegativeInteger |
pool_queued_async_temp_data_pages -
Data pages prefetch requests for temporary table spaces monitor element |
pool_queued_async_temp_data_reqs |
xs:nonNegativeInteger |
pool_queued_async_temp_data_reqs -
Data prefetch requests for temporary table spaces monitor element |
pool_queued_async_temp_index_pages |
xs:nonNegativeInteger |
pool_queued_async_temp_index_pages
- Index pages prefetch requests for temporary table spaces monitor
element |
pool_queued_async_temp_index_reqs |
xs:nonNegativeInteger |
pool_queued_async_temp_index_reqs -
Index prefetch requests for temporary table spaces monitor element |
pool_queued_async_temp_xda_pages |
xs:nonNegativeInteger |
pool_queued_async_temp_xda_pages -
XDA data pages prefetch requests for temporary table spaces monitor
element |
pool_queued_async_temp_xda_reqs |
xs:nonNegativeInteger |
pool_queued_async_temp_xda_reqs - XDA
data prefetch requests for temporary table spaces monitor element |
pool_queued_async_xda_pages |
xs:nonNegativeInteger |
pool_queued_async_xda_pages - XDA pages
prefetch requests |
pool_queued_async_xda_reqs |
xs:nonNegativeInteger |
pool_queued_async_xda_reqs - XDA prefetch
requests monitor element |
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_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_sorts |
xs:nonNegativeInteger |
post_shrthreshold_sorts - Post shared
threshold sorts |
post_threshold_peas |
xs:long |
post_threshold_peas - Partial early
aggregation threshold monitor element |
post_threshold_peds |
xs:long |
post_threshold_peds - Partial early
distincts threshold monitor element |
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
monitor element |
query_actual_degree |
xs:int |
query_actual_degree - Actual runtime
degree of intrapartition parallelism monitor element |
query_cost_estimate |
xs:integer |
query_cost_estimate - Query cost estimate |
query_data_tag_list |
xs:string(32) |
query_data_tag_list - Query data tag
list |
routine_id |
xs:nonNegativeInteger |
routine_id - Routine ID |
rows_modified |
xs:nonNegativeInteger |
rows_modified - Rows modified |
rows_read |
xs:nonNegativeInteger |
rows_read - Rows read |
rows_returned |
xs:nonNegativeInteger |
rows_returned - Rows returned |
section_number |
xs:integer |
section_number - Section number |
service_class_id |
xs:integer |
service_class_id - Service class |
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 |
sort_overflows |
xs:nonNegativeInteger |
sort_overflows - Sort overflows |
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 |
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 |
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 |
stmt_exec_time |
xs:nonNegativeInteger |
stmt_exec_time - Statement
execution time |
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. |
stmtno |
xs:int |
stmtno - Statement number monitor element |
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_section_executions |
xs:nonNegativeInteger |
total_app_section_executions
- Total section executions |
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 monitor element in microseconds |
total_extended_latch_wait_time |
xs:nonNegativeInteger |
total_extended_latch_wait_time - Total
extended latch wait time monitor element |
total_extended_latch_waits |
xs:nonNegativeInteger |
total_extended_latch_waits - Total
extended latch waits monitor element |
total_peas |
xs:long |
total_peas - Total partial early aggregations
monitor element |
total_peds |
xs:long |
total_peds - Total partial early distincts
monitor element |
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_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 |
tq_sort_heap_rejections |
xs:long |
tq_sort_heap_rejections - Table queue
sort heap rejections monitor element |
tq_sort_heap_requests |
xs:long |
tq_sort_heap_requests - Table queue
sort heap requests monitor element |
tq_tot_send_spills |
xs:nonNegativeInteger |
tq_tot_send_spills - Total number of
tablequeue buffers overflowed |
uow_id |
xs:nonNegativeInteger |
uow_id - Unit of work ID |
utility_id |
xs:nonNegativeInteger |
utility_id - Utility ID |
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 |
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 |