audit_events_total |
xs:long |
audit_events_total - Total audit events |
audit_file_write_wait_time |
xs:long |
audit_file_write_wait_time - Audit
file write wait time |
audit_file_writes_total |
xs:long |
audit_file_writes_total - Total Audit
files written |
audit_subsystem_wait_time |
xs:long |
audit_subsystem_wait_time - Audit subsystem
wait time |
audit_subsystem_waits_total |
xs:long |
audit_subsystem_waits_total - Total
audit subsystem waits |
comp_env_desc |
xs:hexBinary(10240) |
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. |
coord_stmt_exec_time |
xs:long |
coord_stmt_exec_time - Execution time
for statement by coordinator agent |
deadlocks |
xs:long |
deadlocks - Deadlocks detected |
diaglog_write_wait_time |
xs:long |
diaglog_write_wait_time - Diag log
write time |
diaglog_writes_total |
xs:long |
diaglog_writes_total - Diag log total
writes |
direct_read_reqs |
xs:long |
direct_read_reqs - Direct read requests |
direct_read_time |
xs:long |
direct_read_time - Direct read time |
direct_reads |
xs:long |
direct_reads - Direct reads from database |
direct_write_reqs |
xs:long |
direct_write_reqs - Direct write requests |
direct_write_time |
xs:long |
direct_write_time - Direct write time |
direct_writes |
xs:long |
direct_writes - Direct writes to database |
disabled_peds |
xs:long |
disabled_peds - Disabled partial early
distincts |
effective_isolation |
xs:string(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. |
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 |
xs:hexBinary(32) |
executable_id - Executable ID. |
fcm_message_recv_volume |
xs:long |
fcm_message_recv_volume - FCM message
recv volume |
fcm_message_recv_wait_time |
xs:long |
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:long |
fcm_message_recvs_total - FCM message
recvs total |
fcm_message_send_volume |
xs:long |
fcm_message_send_volume - FCM message
send volume |
fcm_message_send_wait_time |
xs:long |
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:long |
fcm_message_sends_total - FCM message
sends total |
fcm_recv_volume |
xs:long |
fcm_recv_volume - FCM recv volume |
fcm_recv_wait_time |
xs:long |
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:long |
fcm_recvs_total - FCM recvs total |
fcm_send_volume |
xs:long |
fcm_send_volume - FCM send volume |
fcm_send_wait_time |
xs:long |
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:long |
fcm_sends_total - FCM sends total |
fcm_tq_recv_volume |
xs:long |
fcm_tq_recv_volume - FCM tablequeue
recv volume |
fcm_tq_recv_wait_time |
xs:long |
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:long |
fcm_tq_recvs_total - FCM tablequeue
recvs total |
fcm_tq_send_volume |
xs:long |
fcm_tq_send_volume - FCM tablequeue
send volume |
fcm_tq_send_wait_time |
xs:long |
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:long |
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. |
insert_timestamp |
xs:dateTime |
insert_timestamp - Statement insert
timestamp |
last_metrics_update |
xs:dateTime |
last_metrics_update - Metrics last
update timestamp |
lock_escals |
xs:long |
lock_escals - Number of lock escalations |
lock_timeouts |
xs:long |
lock_timeouts - Number of lock timeouts |
lock_wait_time |
xs:long |
lock_wait_time - Time waited on locks |
lock_waits |
xs:long |
lock_waits - Lock waits |
log_buffer_wait_time |
xs:long |
log_buffer_wait_time - Log buffer wait
time |
log_disk_wait_time |
xs:long |
log_disk_wait_time - Log disk wait
time |
log_disk_waits_total |
xs:long |
log_disk_waits_total - Log disk waits
total |
max_coord_stmt_exec_time |
xs:nonNegativeInteger |
max_coord_stmt_exec_time - Maximum
coordinator statement execution time |
max_coord_stmt_exec_time_args |
logical-grouping |
max_coord_stmt_exec_time_args - Maximum
coordinator statement execution time arguments |
max_coord_stmt_exec_timestamp |
xs:dateTime |
max_coord_stmt_exec_timestamp - Maximum
coordinator statement execution timestamp |
member |
xs:short |
member- Database member |
num_coord_exec |
xs:long |
num_coord_exec - Number of executions
by coordinator agent |
num_coord_exec_with_metrics |
xs:long |
num_coord_exec_with_metrics - Number
of executions by coordinator agent with metrics |
num_exec_with_metrics |
xs:nonNegativeInteger |
num_exec_with_metrics - Number of executions
with metrics collected. |
num_executions |
xs:nonNegativeInteger |
num_executions - Statement executions |
num_log_buffer_full |
xs:long |
num_log_buffer_full - Number of full
log buffers |
num_lw_thresh_exceeded |
xs:long |
num_lw_thresh_exceeded - Number of
thresholds exceeded |
num_routines |
xs:int |
num_routines -Number of routines |
num_working_copies |
xs:long |
Number of working copies. |
package_name |
xs:string(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_schema |
xs:string(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_version_id |
xs:string(64) |
package_version_id - Package version. This output
is valid for static SQL statements only. This element is not produced
if the statement is dynamic or if you did not specify the package
version for static statement. If you did not specify the package version
identifier when the package was created, an empty string is returned
for a static statement. |
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:long |
pool_data_l_reads - Buffer pool data
logical reads |
pool_data_p_reads |
xs:long |
pool_data_p_reads - Buffer pool data
physical reads |
pool_data_writes |
xs:long |
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:long |
pool_index_l_reads - Buffer pool index
logical reads |
pool_index_p_reads |
xs:long |
pool_index_p_reads - Buffer pool index
physical reads |
pool_index_writes |
xs:long |
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_reqs |
xs:nonNegativeInteger |
pool_queued_async_xda_reqs - XDA prefetch
requests monitor element |
pool_read_time |
xs:long |
pool_read_time - Total buffer pool
physical read time |
pool_temp_data_l_reads |
xs:long |
pool_temp_data_l_reads - Buffer pool
temporary data logical reads |
pool_temp_data_p_reads |
xs:long |
pool_temp_data_p_reads - Buffer pool
temporary data physical reads |
pool_temp_index_l_reads |
xs:long |
pool_temp_index_l_reads - Buffer pool
temporary index logical reads |
pool_temp_index_p_reads |
xs:long |
pool_temp_index_p_reads - Buffer pool
temporary index physical reads |
pool_temp_xda_p_reads |
xs:long |
pool_temp_xda_p_reads - Buffer pool
temporary XDA data physical reads |
pool_write_time |
xs:long |
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_lbp_pages_found |
xs:nonNegativeInteger |
pool_xda_lbp_pages_found - Local buffer
pool XDA data pages found |
pool_xda_p_reads |
xs:long |
pool_xda_p_reads - Buffer pool XDA
data physical reads |
pool_xda_writes |
xs:long |
pool_xda_writes - Buffer pool XDA data
writes |
post_shrthreshold_sorts |
xs:long |
post_shrthreshold_sorts - Post shared
threshold sorts |
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:long |
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 |
prep_time |
xs:nonNegativeInteger |
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. |
query_cost_estimate |
xs:long |
query_cost_estimate - Query cost estimate |
query_data_tag_list |
xs:string(32) |
query_data_tag_list - Query data tag
list |
routine_id |
xs:long |
routine_id - Routine ID. For CALL statements
provides the routine identifier for the target procedure. For all
other types of statements the value is 0. |
rows_modified |
xs:long |
rows_modified - Rows modified |
rows_read |
xs:long |
rows_read - Rows read |
rows_returned |
xs:long |
rows_returned - Rows returned |
section_number |
xs:short |
section_number - Section number. This element
is not produced if the statement is dynamic. |
section_type |
xs:string(1) |
section_type - Section type indicator. |
sort_overflows |
xs:long |
sort_overflows - Sort overflows |
stmt_exec_time |
xs:long |
stmt_exec_time - Statement execution
time |
stmt_pkg_cache_id |
xs:long |
stmt_pkgcache_id - Statement package
cache identifier |
stmt_text |
xs:string(2097152) |
stmt_text - SQL statement text |
stmt_type_id |
xs:string |
stmt_type_id - Statement type identifier |
stmt_value_data |
xs:string(32768) |
stmt_value_data - Value data |
stmt_value_index |
xs:nonNegativeInteger |
stmt_value_index - Value index |
stmt_value_isnull |
xs:string(20) |
stmt_value_isnull - Value has null
value |
stmt_value_isreopt |
xs:string(20) |
stmt_value_isreopt - Variable used
for statement reoptimization |
stmt_value_type |
xs:string(255) |
stmt_value_type - Value type |
stmtno |
xs:int |
stmtno - Statement number monitor element |
thresh_violations |
xs:long |
thresh_violations
- Number of threshold violations |
total_act_time |
xs:long |
total_act_time - Total activity time |
total_act_wait_time |
xs:long |
total_act_wait_time - Total activity
wait time |
total_app_section_executions |
xs:long |
total_app_section_executions - Total
section executions |
total_cpu_time |
xs:long |
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_peas |
xs:long |
total_peas - Total partial early aggregations |
total_peds |
xs:long |
total_peds - Total partial early distincts |
total_routine_invocations |
xs:long |
total_routine_invocations - Total routine
invocations |
total_routine_non_sect_proc_time |
xs:long |
total_routine_non_sect_proc_time -
Non-section processing time |
total_routine_non_sect_time |
xs:long |
total_routine_non_sect_time - Non-section
routine execution time |
total_routine_time |
xs:long |
total_routine_time - Total routine
time |
total_routine_user_code_proc_time |
xs:long |
total_routine_user_code_proc_time -
Total routine user code processing time |
total_routine_user_code_time |
xs:long |
total_routine_user_code_time - Total
routine user code time |
total_section_proc_time |
xs:long |
total_section_proc_time - Total section
processing time |
total_section_sort_proc_time |
xs:long |
total_section_sort_proc_time - Total
section sort processing time |
total_section_sort_time |
xs:long |
total_section_sort_time - Total section
sort time |
total_section_sorts |
xs:long |
total_section_sorts - Total section
sorts |
total_section_time |
xs:long |
total_section_time - Total section
time |
total_sorts |
xs:long |
total_sorts - Total Sorts |
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_time |
xs:nonNegativeInteger |
total_sync_runstats_time - Total synchronous
RUNSTATS 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:long |
tq_tot_send_spills - Total number of
table queue buffers overflowed |
valid |
xs:string(1) |
valid - Section validity indicator |
wlm_queue_assignments_total |
xs:long |
wlm_queue_assignments_total - Workload
manager total queue assignments |
wlm_queue_time_total |
xs:long |
wlm_queue_time_total - Workload manager
total queue time |