APPL_SECTION_INSERTS |
BIGINT |
appl_section_inserts
- Section inserts |
APPL_SECTION_LOOKUPS |
BIGINT |
appl_section_lookups
- Section lookups |
ASYNC_RUNSTATS |
BIGINT |
async_runstats
- Total number of asynchronous RUNSTATS requests |
BINDS_PRECOMPILES |
BIGINT |
binds_precompiles
- Binds/precompiles attempted |
BLOCKS_PENDING_CLEANUP |
BIGINT |
blocks_pending_cleanup
- Pending cleanup rolled-out blocks |
CAT_CACHE_HEAP_FULL |
BIGINT |
cat_cache_heap_full - Catalog cache
heap full |
CAT_CACHE_INSERTS |
BIGINT |
cat_cache_inserts
- Catalog cache inserts |
CAT_CACHE_LOOKUPS |
BIGINT |
cat_cache_lookups
- Catalog cache lookups |
CAT_CACHE_OVERFLOWS |
BIGINT |
cat_cache_overflows
- Catalog cache overflows |
CAT_CACHE_SIZE_TOP |
BIGINT |
cat_cache_size_top
- Catalog cache high watermark |
CATALOG_NODE |
BIGINT |
catalog_node
- Catalog node number |
CATALOG_NODE_NAME |
VARCHAR(32) |
catalog_node_name
- Catalog node network name |
COMMIT_SQL_STMTS |
BIGINT |
commit_sql_stmts
- Commit statements attempted |
CONNECTIONS_TOP |
BIGINT |
connections_top
- Maximum number of concurrent connections |
DB_HEAP_TOP |
BIGINT |
db_heap_top
- Maximum database heap allocated |
DDL_SQL_STMTS |
BIGINT |
ddl_sql_stmts
- Data definition language (DDL) SQL statements |
DEADLOCKS |
BIGINT |
deadlocks
- Deadlocks detected |
DIRECT_READ_REQS |
BIGINT |
direct_read_reqs
- Direct read requests |
DIRECT_READ_TIME |
BIGINT |
direct_read_time
- Direct read time |
DIRECT_READS |
BIGINT |
direct_reads
- Direct reads from database |
DIRECT_WRITE_REQS |
BIGINT |
direct_write_reqs
- Direct write requests |
DIRECT_WRITE_TIME |
BIGINT |
direct_write_time
- Direct write time |
DIRECT_WRITES |
BIGINT |
direct_writes
- Direct writes to database |
DISCONN_TIME |
TIMESTAMP |
disconn_time
- Database deactivation timestamp |
DYNAMIC_SQL_STMTS |
BIGINT |
dynamic_sql_stmts
- Dynamic SQL statements attempted |
ELAPSED_EXEC_TIME |
BIGINT |
elapsed_exec_time
- Statement execution elapsed time |
EVMON_ACTIVATES |
BIGINT |
evmon_activates
- Number of event monitor activations |
EVMON_FLUSHES |
BIGINT |
evmon_flushes
- Number of event monitor flushes |
FAILED_SQL_STMTS |
BIGINT |
failed_sql_stmts
- Failed statement operations |
FILES_CLOSED |
BIGINT |
files_closed
- Database files closed |
HASH_JOIN_OVERFLOWS |
BIGINT |
hash_join_overflows
- Hash join overflows |
HASH_JOIN_SMALL_OVERFLOWS |
BIGINT |
hash_join_small_overflows
- Hash join small overflows |
INT_AUTO_REBINDS |
BIGINT |
int_auto_rebinds
- Internal automatic rebinds |
INT_COMMITS |
BIGINT |
int_commits
- Internal commits |
INT_ROLLBACKS |
BIGINT |
int_rollbacks
- Internal rollbacks |
INT_ROWS_DELETED |
BIGINT |
int_rows_deleted
- Internal rows deleted |
INT_ROWS_INSERTED |
BIGINT |
int_rows_inserted
- Internal rows inserted |
INT_ROWS_UPDATED |
BIGINT |
int_rows_updated
- Internal rows updated |
LOCK_ESCALS |
BIGINT |
lock_escals
- Number of lock escalations |
LOCK_TIMEOUTS |
BIGINT |
lock_timeouts
- Number of lock timeouts |
LOCK_WAIT_TIME |
BIGINT |
lock_wait_time
- Time waited on locks |
LOCK_WAITS |
BIGINT |
lock_waits
- Lock waits |
LOG_FILE_ARCHIVE |
BIGINT |
|
LOG_FILE_NUM_CURR |
BIGINT |
|
LOG_FILE_NUM_FIRST |
BIGINT |
|
LOG_FILE_NUM_LAST |
BIGINT |
|
LOG_HELD_BY_DIRTY_PAGES |
BIGINT |
log_held_by_dirty_pages
- Amount of log space accounted for by dirty pages |
LOG_READ_TIME |
BIGINT |
log_read_time
- Log read time |
LOG_READS |
BIGINT |
log_reads
- Number of log pages read |
LOG_TO_REDO_FOR_RECOVERY |
BIGINT |
log_to_redo_for_recovery
- Amount of log to be redone for recovery |
LOG_WRITE_TIME |
BIGINT |
log_write_time
- Log write time |
LOG_WRITES |
BIGINT |
log_writes
- Number of log pages written |
NUM_LOG_BUFF_FULL |
BIGINT |
|
NUM_LOG_DATA_IN_BUFF |
BIGINT |
|
NUM_LOG_PART_PAGE_IO |
BIGINT |
num_log_part_page_io
- Number of partial log page writes |
NUM_LOG_READ_IO |
BIGINT |
num_log_read_io
- Number of log reads |
NUM_LOG_WRITE_IO |
BIGINT |
num_log_write_io
- Number of log writes |
NUM_THRESHOLD_VIOLATIONS |
INTEGER |
num_threshold_violations
- Number of threshold violations |
OLAP_FUNC_OVERFLOWS |
BIGINT |
olap_func_overflows
- OLAP function overflows |
PARTIAL_RECORD |
SMALLINT |
partial_record
- Partial record |
PKG_CACHE_INSERTS |
BIGINT |
pkg_cache_inserts
- Package cache inserts |
PKG_CACHE_LOOKUPS |
BIGINT |
pkg_cache_lookups
- Package cache lookups |
PKG_CACHE_NUM_OVERFLOWS |
BIGINT |
pkg_cache_num_overflows
- Package cache overflows |
PKG_CACHE_SIZE_TOP |
BIGINT |
pkg_cache_size_top
- Package cache high watermark |
POOL_ASYNC_DATA_READ_REQS |
BIGINT |
pool_async_data_read_reqs
- Buffer pool asynchronous read requests |
POOL_ASYNC_DATA_READS |
BIGINT |
pool_async_data_reads
- Buffer pool asynchronous data reads |
POOL_ASYNC_DATA_WRITES |
BIGINT |
pool_async_data_writes
- Buffer pool asynchronous data writes |
POOL_ASYNC_INDEX_READ_REQS |
BIGINT |
pool_async_index_read_reqs
- Buffer pool asynchronous index read requests |
POOL_ASYNC_INDEX_READS |
BIGINT |
pool_async_index_reads
- Buffer pool asynchronous index reads |
POOL_ASYNC_INDEX_WRITES |
BIGINT |
pool_async_index_writes
- Buffer pool asynchronous index writes |
POOL_ASYNC_READ_TIME |
BIGINT |
pool_async_read_time
- Buffer pool asynchronous read time |
POOL_ASYNC_WRITE_TIME |
BIGINT |
pool_async_write_time
- Buffer pool asynchronous write time |
POOL_ASYNC_XDA_READ_REQS |
BIGINT |
pool_async_xda_read_reqs
- Buffer pool asynchronous XDA read requests |
POOL_ASYNC_XDA_READS |
BIGINT |
pool_async_xda_reads
- Buffer pool asynchronous XDA data reads |
POOL_ASYNC_XDA_WRITES |
BIGINT |
pool_async_xda_writes
- Buffer pool asynchronous XDA data writes |
POOL_DATA_L_READS |
BIGINT |
pool_data_l_reads
- Buffer pool data logical reads |
POOL_DATA_P_READS |
BIGINT |
pool_data_p_reads
- Buffer pool data physical reads |
POOL_DATA_WRITES |
BIGINT |
pool_data_writes
- Buffer pool data writes |
POOL_DRTY_PG_STEAL_CLNS |
BIGINT |
pool_drty_pg_steal_clns
- Buffer pool victim page cleaners triggered |
POOL_DRTY_PG_THRSH_CLNS |
BIGINT |
pool_drty_pg_thrsh_clns
- Buffer pool threshold cleaners triggered |
POOL_INDEX_L_READS |
BIGINT |
pool_index_l_reads
- Buffer pool index logical reads |
POOL_INDEX_P_READS |
BIGINT |
pool_index_p_reads
- Buffer pool index physical reads |
POOL_INDEX_WRITES |
BIGINT |
pool_index_writes
- Buffer pool index writes |
POOL_LSN_GAP_CLNS |
BIGINT |
pool_lsn_gap_clns
- Buffer pool log space cleaners triggered |
POOL_NO_VICTIM_BUFFER |
BIGINT |
pool_no_victim_buffer
- Buffer pool no victim buffers |
POOL_READ_TIME |
BIGINT |
pool_read_time
- Total buffer pool physical read time |
POOL_TEMP_DATA_L_READS |
BIGINT |
pool_temp_data_l_reads
- Buffer pool temporary data logical reads |
POOL_TEMP_DATA_P_READS |
BIGINT |
pool_temp_data_p_reads
- Buffer pool temporary data physical reads |
POOL_TEMP_INDEX_L_READS |
BIGINT |
pool_temp_index_l_reads
- Buffer pool temporary index logical reads |
POOL_TEMP_INDEX_P_READS |
BIGINT |
pool_temp_index_p_reads
- Buffer pool temporary index physical reads |
POOL_TEMP_XDA_L_READS |
BIGINT |
pool_temp_xda_l_reads
- Buffer pool temporary XDA data logical reads |
POOL_TEMP_XDA_P_READS |
BIGINT |
pool_temp_xda_p_reads
- Buffer pool temporary XDA data physical reads |
POOL_WRITE_TIME |
BIGINT |
pool_write_time
- Total buffer pool physical write time |
POOL_XDA_L_READS |
BIGINT |
pool_xda_l_reads
- Buffer pool XDA data logical reads |
POOL_XDA_P_READS |
BIGINT |
pool_xda_p_reads
- Buffer pool XDA data physical reads |
POOL_XDA_WRITES |
BIGINT |
pool_xda_writes
- Buffer pool XDA data writes |
POST_SHRTHRESHOLD_HASH_JOINS |
BIGINT |
post_shrthreshold_hash_joins
- Post threshold hash joins |
POST_SHRTHRESHOLD_SORTS |
BIGINT |
post_shrthreshold_sorts
- Post shared threshold sorts |
PREFETCH_WAIT_TIME |
BIGINT |
prefetch_wait_time
- Time waited for prefetch |
ROLLBACK_SQL_STMTS |
BIGINT |
rollback_sql_stmts
- Rollback statements attempted |
ROWS_DELETED |
BIGINT |
rows_deleted
- Rows deleted |
ROWS_INSERTED |
BIGINT |
rows_inserted
- Rows inserted |
ROWS_READ |
BIGINT |
rows_read
- Rows read |
ROWS_SELECTED |
BIGINT |
rows_selected
- Rows selected |
ROWS_UPDATED |
BIGINT |
rows_updated
- Rows updated |
SEC_LOG_USED_TOP |
BIGINT |
sec_log_used_top
- Maximum secondary log space used |
SELECT_SQL_STMTS |
BIGINT |
select_sql_stmts
- Select SQL statements executed |
SERVER_PLATFORM |
INTEGER |
server_platform
- Server operating system |
SORT_OVERFLOWS |
BIGINT |
sort_overflows
- Sort overflows |
SORT_SHRHEAP_TOP |
BIGINT |
sort_shrheap_top
- Sort share heap high watermark |
STATIC_SQL_STMTS |
BIGINT |
static_sql_stmts
- Static SQL statements attempted |
STATS_CACHE_SIZE |
BIGINT |
stats_cache_size
- Size of statistics cache |
STATS_FABRICATE_TIME |
BIGINT |
stats_fabricate_time
- Total time spent on statistics fabrication activities |
STATS_FABRICATIONS |
BIGINT |
stats_fabrications
- Total number of statistics fabrications |
SYNC_RUNSTATS |
BIGINT |
sync_runstats
- Total number of synchronous RUNSTATS activities |
SYNC_RUNSTATS_TIME |
BIGINT |
sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element |
TOT_LOG_USED_TOP |
BIGINT |
tot_log_used_top
- Maximum total log space used |
TOTAL_CONS |
BIGINT |
total_cons
- Connects since database activation |
TOTAL_HASH_JOINS |
BIGINT |
total_hash_joins
- Total hash joins |
TOTAL_HASH_LOOPS |
BIGINT |
total_hash_loops
- Total hash loops |
TOTAL_OLAP_FUNCS |
BIGINT |
total_olap_funcs
- Total OLAP functions |
TOTAL_SORT_TIME |
BIGINT |
total_sort_time
- Total sort time |
TOTAL_SORTS |
BIGINT |
total_sorts
- Total sorts |
UID_SQL_STMTS |
BIGINT |
uid_sql_stmts
- UPDATE/INSERT/DELETE SQL statements executed |
UNREAD_PREFETCH_PAGES |
BIGINT |
unread_prefetch_pages
- Unread prefetch pages |
X_LOCK_ESCALS |
BIGINT |
x_lock_escals
- Exclusive lock escalations |
XQUERY_STMTS |
BIGINT |
xquery_stmts
- XQuery Statements Attempted |