SNAPSHOT_TIMESTAMP |
TIMESTAMP |
The date and time that the snapshot was taken. |
TBSP_NAME |
VARCHAR(128) |
tablespace_name - Table space name |
TBSP_ID |
BIGINT |
tablespace_id - Table space identification |
TBSP_TYPE |
VARCHAR(10) |
tablespace_type - Table space type . This interface
returns a text identifier based on defines in sqlutil.h,
and is one of:
|
TBSP_CONTENT_TYPE |
VARCHAR(10) |
tablespace_content_type - Table space
contents type . This interface returns a text identifier
based on defines in sqlmon.h, and is one of:
- ANY
- LARGE
- SYSTEMP
- USRTEMP
|
TBSP_PAGE_SIZE |
BIGINT |
tablespace_page_size - Table space
page size |
TBSP_EXTENT_SIZE |
BIGINT |
tablespace_extent_size - Table space
extent size |
TBSP_PREFETCH_SIZE |
BIGINT |
tablespace_prefetch_size - Table space
prefetch size |
TBSP_CUR_POOL_ID |
BIGINT |
tablespace_cur_pool_id - Buffer pool
currently being used |
TBSP_NEXT_POOL_ID |
BIGINT |
tablespace_next_pool_id - Buffer pool
that will be used at next startup |
FS_CACHING |
SMALLINT |
fs_caching - File system caching |
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_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_ASYNC_DATA_READS |
BIGINT |
pool_async_data_reads - Buffer pool
asynchronous data reads |
POOL_DATA_WRITES |
BIGINT |
pool_data_writes - Buffer pool data
writes |
POOL_ASYNC_DATA_WRITES |
BIGINT |
pool_async_data_writes - Buffer pool
asynchronous 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_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_ASYNC_INDEX_READS |
BIGINT |
pool_async_index_reads - Buffer pool
asynchronous index reads |
POOL_INDEX_WRITES |
BIGINT |
pool_index_writes - Buffer pool index
writes |
POOL_ASYNC_INDEX_WRITES |
BIGINT |
pool_async_index_writes - Buffer pool
asynchronous 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_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_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_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_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 |
POOL_NO_VICTIM_BUFFER |
BIGINT |
pool_no_victim_buffer - Buffer pool
no victim buffers |
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 |
FILES_CLOSED |
BIGINT |
files_closed - Database files closed |
UNREAD_PREFETCH_PAGES |
BIGINT |
unread_prefetch_pages - Unread prefetch
pages |
TBSP_REBALANCER_MODE |
VARCHAR(10) |
tablespace_rebalancer_mode - Rebalancer
mode . This interface returns a text identifier based on defines
in sqlmon.h, and is one of: - NO_REBAL
- FWD_REBAL
- REV_REBAL
|
TBSP_USING_AUTO_STORAGE |
SMALLINT |
tablespace_using_auto_storage - Table
space enabled for automatic storage |
TBSP_AUTO_RESIZE_ENABLED |
SMALLINT |
tablespace_auto_resize_enabled - Table
space automatic resizing enabled |
DBPARTITIONNUM |
SMALLINT |
dbpartitionnum - Database partition
number monitor element |