ACC_CURS_BLK |
BIGINT |
acc_curs_blk - Accepted
block cursor requests |
AGENT_ID |
BIGINT |
agent_id - Application
handle (agent ID) |
APPL_ID |
VARCHAR(64) |
appl_id - Application
ID |
APPL_PRIORITY |
BIGINT |
appl_priority - Application
agent priority |
APPL_PRIORITY_TYPE |
BIGINT |
appl_priority_type
- Application priority type |
APPL_SECTION_INSERTS |
BIGINT |
appl_section_inserts
- Section inserts |
APPL_SECTION_LOOKUPS |
BIGINT |
appl_section_lookups
- Section lookups |
APPL_STATUS |
BIGINT |
appl_status - Application
status |
AUTHORITY_BITMAP |
CHARACTER(22) |
authority_bitmap
- User authorization level |
AUTHORITY_LVL |
BIGINT |
authority_lvl - User
authorization level |
BINDS_PRECOMPILES |
BIGINT |
binds_precompiles
- Binds/precompiles attempted |
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 |
COMMIT_SQL_STMTS |
BIGINT |
commit_sql_stmts
- Commit statements attempted |
COORD_NODE |
BIGINT |
coord_node - Coordinating
node |
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_FLUSHES |
BIGINT |
evmon_flushes - Number
of event monitor flushes |
FAILED_SQL_STMTS |
BIGINT |
failed_sql_stmts
- Failed statement operations |
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_DEADLOCK_ROLLBACKS |
BIGINT |
int_deadlock_rollbacks
- Internal rollbacks due to deadlock |
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 |
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 |
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_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_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 |
PREFETCH_WAIT_TIME |
BIGINT |
prefetch_wait_time
- Time waited for prefetch |
REJ_CURS_BLK |
BIGINT |
rej_curs_blk - Rejected
block cursor requests |
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 |
ROWS_WRITTEN |
BIGINT |
rows_written - Rows
written |
SELECT_SQL_STMTS |
BIGINT |
select_sql_stmts
- Select SQL statements executed |
SEQUENCE_NO |
CHARACTER(5) |
sequence_no - Sequence
number |
SORT_OVERFLOWS |
BIGINT |
sort_overflows -
Sort overflows |
STATIC_SQL_STMTS |
BIGINT |
static_sql_stmts
- Static SQL statements attempted |
SYSTEM_CPU_TIME |
BIGINT |
system_cpu_time -
System CPU time |
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 |
USER_CPU_TIME |
BIGINT |
user_cpu_time - User
CPU time |
X_LOCK_ESCALS |
BIGINT |
x_lock_escals - Exclusive
lock escalations |
XQUERY_STMTS |
BIGINT |
xquery_stmts - XQuery
Statements Attempted |