SNAPSHOT_TIMESTAMP |
TIMESTAMP |
snapshot_timestamp - Snapshot timestamp
monitor element |
BP_NAME |
VARCHAR(128) |
bp_name - Buffer pool name |
DB_NAME |
VARCHAR(128) |
db_name - Database name |
DB_PATH |
VARCHAR(1024) |
db_path - Database path |
INPUT_DB_ALIAS |
VARCHAR(128) |
input_db_alias - Input database alias |
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_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 |
POOL_READ_TIME |
BIGINT |
pool_read_time - Total buffer pool
physical read time |
POOL_WRITE_TIME |
BIGINT |
pool_write_time - Total buffer pool
physical write time |
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_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_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_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_DATA_
READ_REQS
|
BIGINT |
pool_async_data_read_reqs - Buffer
pool asynchronous read requests |
POOL_ASYNC_INDEX_
READ_REQS
|
BIGINT |
pool_async_index_read_reqs - Buffer
pool asynchronous index read requests |
POOL_ASYNC_XDA_
READ_REQS
|
BIGINT |
pool_async_xda_read_reqs - Buffer Pool
Asynchronous XDA Read Requests |
DIRECT_READS |
BIGINT |
direct_reads - Direct reads from database |
DIRECT_WRITES |
BIGINT |
direct_writes - Direct writes to database |
DIRECT_READ_REQS |
BIGINT |
direct_read_reqs - Direct read requests |
DIRECT_WRITE_REQS |
BIGINT |
direct_write_reqs - Direct write requests |
DIRECT_READ_TIME |
BIGINT |
direct_read_time - Direct read time |
DIRECT_WRITE_TIME |
BIGINT |
direct_write_time - Direct write time |
UNREAD_PREFETCH_PAGES |
BIGINT |
unread_prefetch_pages - Unread prefetch
pages |
FILES_CLOSED |
BIGINT |
files_closed - Database files closed |
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 monitor element |
POOL_NO_VICTIM_BUFFER |
BIGINT |
pool_no_victim_buffer - Buffer pool
no victim buffers |
PAGES_FROM_BLOCK_IOS |
BIGINT |
pages_from_block_ios - Total number
of pages read by block I/O |
PAGES_FROM_VECTORED_IOS
|
BIGINT |
pages_from_vectored_ios - Total pages
read by vectored I/O |
PHYSICAL_PAGE_MAPS |
BIGINT |
The physical_page_maps monitor element is discontinued.
A NULL value is returned for the discontinued monitor element. |
VECTORED_IOS |
BIGINT |
vectored_ios - Number of vectored I/O
requests |
DBPARTITIONNUM |
SMALLINT |
The database partition from which the data was
retrieved for this row. |