TBSP_NAME |
VARCHAR(128) |
tablespace_name - Table space name |
TBSP_ID |
BIGINT |
tablespace_id - Table space identification |
MEMBER |
SMALLINT |
member- Database member |
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
content 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 |
TBSP_REBALANCER_MODE |
VARCHAR(30) |
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
- FWD_REBAL_OF_2PASS
- REV_REBAL_OF_2PASS
|
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 |
DIRECT_READS |
BIGINT |
direct_reads - Direct reads from database |
DIRECT_READ_REQS |
BIGINT |
direct_read_reqs - Direct read requests |
DIRECT_WRITES |
BIGINT |
direct_writes - Direct writes to database |
DIRECT_WRITE_REQS |
BIGINT |
direct_write_reqs - Direct write requests |
POOL_DATA_L_READS |
BIGINT |
pool_data_l_reads - Buffer pool data
logical reads |
POOL_TEMP_DATA_L_READS |
BIGINT |
pool_temp_data_l_reads - Buffer pool
temporary data logical reads |
POOL_XDA_L_READS |
BIGINT |
pool_xda_l_reads - Buffer pool XDA
data logical reads |
POOL_TEMP_XDA_L_READS |
BIGINT |
pool_temp_xda_l_reads - Buffer pool
temporary XDA data logical reads |
POOL_INDEX_L_READS |
BIGINT |
pool_index_l_reads - Buffer pool index
logical reads |
POOL_TEMP_INDEX_L_READS |
BIGINT |
pool_temp_index_l_reads - Buffer pool
temporary index logical reads |
POOL_DATA_P_READS |
BIGINT |
pool_data_p_reads - Buffer pool data
physical reads |
POOL_TEMP_DATA_P_READS |
BIGINT |
pool_temp_data_p_reads - Buffer pool
temporary data physical reads |
POOL_XDA_P_READS |
BIGINT |
pool_xda_p_reads - Buffer pool XDA
data physical reads |
POOL_TEMP_XDA_P_READS |
BIGINT |
pool_temp_xda_p_reads - Buffer pool
temporary XDA data physical reads |
POOL_INDEX_P_READS |
BIGINT |
pool_index_p_reads - Buffer pool index
physical reads |
POOL_TEMP_INDEX_P_READS |
BIGINT |
pool_temp_index_p_reads - Buffer pool
temporary index physical reads |
POOL_DATA_WRITES |
BIGINT |
pool_data_writes - Buffer pool data
writes |
POOL_XDA_WRITES |
BIGINT |
pool_xda_writes - Buffer pool XDA data
writes |
POOL_INDEX_WRITES |
BIGINT |
pool_index_writes - Buffer pool index
writes |
DIRECT_READ_TIME |
BIGINT |
direct_read_time - Direct read time |
DIRECT_WRITE_TIME |
BIGINT |
direct_write_time - Direct write time |
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_READ_REQS |
BIGINT |
pool_async_data_read_reqs - Buffer
pool asynchronous read requests |
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_READ_REQS |
BIGINT |
pool_async_index_read_reqs - Buffer
pool asynchronous index read requests |
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_READ_REQS |
BIGINT |
pool_async_xda_read_reqs - Buffer pool
asynchronous XDA read requests |
POOL_ASYNC_XDA_WRITES |
BIGINT |
pool_async_xda_writes - Buffer pool
asynchronous XDA data writes |
VECTORED_IOS |
BIGINT |
vectored_ios - Number of vectored IO
requests |
PAGES_FROM_VECTORED_IOS |
BIGINT |
pages_from_vectored_ios - Total number
of pages read by vectored IO |
BLOCK_IOS |
BIGINT |
block_ios - Number of block IO requests |
PAGES_FROM_BLOCK_IOS |
BIGINT |
pages_from_block_ios - Total number
of pages read by block IO |
UNREAD_PREFETCH_PAGES |
BIGINT |
unread_prefetch_pages - Unread prefetch
pages |
FILES_CLOSED |
BIGINT |
files_closed - Database files closed |
TBSP_STATE |
VARCHAR(256) |
tablespace_state - Table space state |
TBSP_USED_PAGES |
BIGINT |
tablespace_used_pages - Used pages
in table space |
TBSP_FREE_PAGES |
BIGINT |
tablespace_free_pages - Free pages
in table space |
TBSP_USABLE_PAGES |
BIGINT |
tablespace_usable_pages - Usable pages
in table space |
TBSP_TOTAL_PAGES |
BIGINT |
tablespace_total_pages - Total pages
in table space |
TBSP_PENDING_FREE_PAGES |
BIGINT |
tablespace_pending_free_pages - Pending
free pages in table space |
TBSP_PAGE_TOP |
BIGINT |
tablespace_page_top - Table space high
watermark |
TBSP_MAX_PAGE_TOP |
BIGINT |
tbsp_max_page_top
- Maximum table space page high watermark |
RECLAIMABLE_SPACE_ENABLED |
SMALLINT |
reclaimable_space_enabled - Reclaimable
space enabled indicator |
AUTO_STORAGE_HYBRID |
SMALLINT |
auto_storage_hybrid - Hybrid automatic
storage table space indicator |
TBSP_PATHS_DROPPED |
SMALLINT |
tablespace_paths_dropped - Table space
using dropped path |
POOL_DATA_GBP_L_READS |
BIGINT |
pool_data_gbp_l_reads
- Group buffer pool data logical reads monitor element |
POOL_DATA_GBP_P_READS |
BIGINT |
pool_data_gbp_p_reads
- Group buffer pool data physical reads monitor element |
POOL_DATA_LBP_PAGES_FOUND |
BIGINT |
pool_data_lbp_pages_found
- Local buffer pool found data pages monitor element |
POOL_DATA_GBP_INVALID_PAGES |
BIGINT |
pool_data_gbp_invalid_pages
- Group buffer pool invalid data pages monitor element |
POOL_INDEX_GBP_L_READS |
BIGINT |
pool_index_gbp_l_reads
- Group buffer pool index logical reads monitor element |
POOL_INDEX_GBP_P_READS |
BIGINT |
pool_index_gbp_p_reads
- Group buffer pool index physical reads monitor elements |
POOL_INDEX_LBP_PAGES_FOUND |
BIGINT |
pool_index_lbp_pages_found
- Local buffer pool index pages found monitor element |
POOL_INDEX_GBP_INVALID_PAGES |
BIGINT |
pool_index_gbp_invalid_pages
- Group buffer pool invalid index pages monitor element |
POOL_ASYNC_DATA_GBP_L_READS |
BIGINT |
pool_async_data_gbp_l_reads
- Group buffer pool asynchronous data logical reads monitor element |
POOL_ASYNC_DATA_GBP_P_READS |
BIGINT |
pool_async_data_gbp_p_reads
- Group buffer pool asynchronous data physical reads monitor element |
POOL_ASYNC_DATA_LBP_PAGES_FOUND |
BIGINT |
pool_async_data_lbp_pages_found
- Local buffer pool asynchronous data pages found monitor element |
POOL_ASYNC_DATA_GBP_INVALID_PAGES |
BIGINT |
pool_async_data_gbp_invalid_pages
- Group buffer pool invalid asynchronous data pages monitor element |
POOL_ASYNC_INDEX_GBP_L_READS |
BIGINT |
pool_async_index_gbp_l_reads
- Group buffer pool asynchronous index logical reads monitor element |
POOL_ASYNC_INDEX_GBP_P_READS |
BIGINT |
pool_async_index_gbp_p_reads
- Group buffer pool asynchronous index physical reads monitor element |
POOL_ASYNC_INDEX_LBP_PAGES_FOUND |
BIGINT |
pool_async_index_lbp_pages_found
- Local buffer pool asynchronous index pages found monitor element |
POOL_ASYNC_INDEX_GBP_INVALID_PAGES |
BIGINT |
pool_async_index_gbp_invalid_pages
- Group buffer pool invalid asynchronous index pages monitor element |
TABLESPACE_MIN_RECOVERY_TIME |
TIMESTAMP |
tablespace_min_recovery_time
- Minimum recovery time for rollforward monitor element |
DBPARTITIONNUM |
SMALLINT |
dbpartitionnum
- Database partition number monitor element For
a partitioned database environment, this will be the same value as
for the MEMBER column. For Db2® Enterprise Server
Edition and
in a Db2
pureScale® environment,
this value will be 0. Note: DBPARTITIONNUM is different to data_partition_id,
which is used to identify a data partition that was created by subdividing
data in a table based on a value.
|
POOL_XDA_GBP_L_READS |
BIGINT |
pool_xda_gbp_l_reads - Group buffer
pool XDA data logical read requests |
POOL_XDA_GBP_P_READS |
BIGINT |
pool_xda_gbp_p_reads - Group buffer
pool XDA data physical read requests |
POOL_XDA_LBP_PAGES_FOUND |
BIGINT |
pool_xda_lbp_pages_found - Local buffer
pool XDA data pages found |
POOL_XDA_GBP_INVALID_PAGES |
BIGINT |
pool_xda_gbp_invalid_pages - Group
buffer pool invalid XDA data pages |
POOL_ASYNC_XDA_GBP_L_READS |
BIGINT |
pool_async_xda_gbp_l_reads - Group
buffer pool XDA data asynchronous logical read requests |
POOL_ASYNC_XDA_GBP_P_READS |
BIGINT |
pool_async_xda_gbp_p_reads - Group
buffer pool XDA data asynchronous physical read requests |
POOL_ASYNC_XDA_LBP_PAGES_FOUND |
BIGINT |
pool_async_xda_lbp_pages_found - Asynchronous
local buffer pool XDA data pages found |
POOL_ASYNC_XDA_GBP_INVALID_PAGES |
BIGINT |
pool_async_xda_gbp_invalid_pages -
Asynchronous group buffer pool invalid XDA data pages |
POOL_ASYNC_READ_TIME |
BIGINT |
pool_async_read_time - Buffer Pool
Asynchronous Read Time monitor element |
POOL_ASYNC_WRITE_TIME |
BIGINT |
pool_async_write_time - Buffer pool
asynchronous write time monitor element |
TBSP_TRACKMOD_STATE |
VARCHAR(32) |
tbsp_trackmod_state - Table space trackmod
state . This interface returns a text identifier, and
is one of:
- CLEAN
- DIRTY
- ININCREMENTAL
- READFULL
- READINCREMENTAL
- UNAVAILABLE
|
STORAGE_GROUP_NAME |
VARCHAR(128) |
storage_group_name - Storage group
name monitor element |
STORAGE_GROUP_ID |
INTEGER |
storage_group_id - Storage group identifier
monitor element |
TBSP_DATATAG |
SMALLINT |
tbsp_datatag - Table space data tag
monitor element |
TBSP_LAST_CONSEC_PAGE |
BIGINT |
tbsp_last_consec_page - Last consecutive
object table page monitor element |
POOL_QUEUED_ASYNC_DATA_REQS |
BIGINT |
pool_queued_async_data_reqs - Data
prefetch requests monitor element |
POOL_QUEUED_ASYNC_INDEX_REQS |
BIGINT |
pool_queued_async_index_reqs - Index
prefetch requests monitor element |
POOL_QUEUED_ASYNC_XDA_REQS |
BIGINT |
pool_queued_async_xda_reqs - XDA prefetch
requests monitor element |
POOL_QUEUED_ASYNC_TEMP_DATA_REQS |
BIGINT |
pool_queued_async_temp_data_reqs -
Data prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_TEMP_INDEX_REQS |
BIGINT |
pool_queued_async_temp_index_reqs -
Index prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_TEMP_XDA_REQS |
BIGINT |
pool_queued_async_temp_xda_reqs - XDA
data prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_OTHER_REQS |
BIGINT |
pool_queued_async_other_reqs - Non-prefetch
requests monitor element |
POOL_QUEUED_ASYNC_DATA_PAGES |
BIGINT |
pool_queued_async_data_pages - Data
pages prefetch requests monitor element |
POOL_QUEUED_ASYNC_INDEX_PAGES |
BIGINT |
pool_queued_async_index_pages - Index
pages prefetch requests monitor element |
POOL_QUEUED_ASYNC_XDA_PAGES |
BIGINT |
pool_queued_async_xda_pages - XDA pages
prefetch requests monitor element |
POOL_QUEUED_ASYNC_TEMP_DATA_PAGES |
BIGINT |
pool_queued_async_temp_data_pages -
Data pages prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES |
BIGINT |
pool_queued_async_temp_index_pages
- Index pages prefetch requests for temporary table spaces monitor
element |
POOL_QUEUED_ASYNC_TEMP_XDA_PAGES |
BIGINT |
pool_queued_async_temp_xda_pages -
XDA data pages prefetch requests for temporary table spaces monitor
element |
POOL_FAILED_ASYNC_DATA_REQS |
BIGINT |
pool_failed_async_data_reqs - Failed
data prefetch requests monitor element |
POOL_FAILED_ASYNC_INDEX_REQS |
BIGINT |
pool_failed_async_index_reqs - Failed
index prefetch requests monitor element |
POOL_FAILED_ASYNC_XDA_REQS |
BIGINT |
pool_failed_async_xda_reqs - Failed
XDA prefetch requests monitor element |
POOL_FAILED_ASYNC_TEMP_DATA_REQS |
BIGINT |
pool_failed_async_temp_data_reqs -
Failed data prefetch requests for temporary table spaces monitor element |
POOL_FAILED_ASYNC_TEMP_INDEX_REQS |
BIGINT |
pool_failed_async_temp_index_reqs -
Failed index prefetch requests for temporary table spaces monitor
element |
POOL_FAILED_ASYNC_TEMP_XDA_REQS |
BIGINT |
pool_failed_async_temp_xda_reqs - Failed
XDA prefetch requests for temporary table spaces monitor element |
POOL_FAILED_ASYNC_OTHER_REQS |
BIGINT |
pool_failed_async_other_reqs - Failed
non-prefetch requests monitor element |
SKIPPED_PREFETCH_DATA_P_READS |
BIGINT |
skipped_prefetch_data_p_reads - Skipped
prefetch data physical reads monitor element |
SKIPPED_PREFETCH_INDEX_P_READS |
BIGINT |
skipped_prefetch_index_p_reads - Skipped
prefetch index physical reads monitor element |
SKIPPED_PREFETCH_XDA_P_READS |
BIGINT |
skipped_prefetch_xda_p_reads - Skipped
prefetch XDA physical reads monitor element |
SKIPPED_PREFETCH_TEMP_DATA_P_READS |
BIGINT |
skipped_prefetch_temp_data_p_reads
- Skipped prefetch temporary data physical reads monitor element |
SKIPPED_PREFETCH_TEMP_INDEX_P_READS |
BIGINT |
skipped_prefetch_temp_index_p_reads
- Skipped prefetch temporary index physical reads monitor element |
SKIPPED_PREFETCH_TEMP_XDA_P_READS |
BIGINT |
skipped_prefetch_temp_xda_p_reads -
Skipped prefetch temporary XDA data physical reads monitor element |
SKIPPED_PREFETCH_UOW_DATA_P_READS |
BIGINT |
skipped_prefetch_uow_data_p_reads -
Skipped prefetch unit of work data physical reads monitor element |
SKIPPED_PREFETCH_UOW_INDEX_P_READS |
BIGINT |
skipped_prefetch_uow_index_p_reads
- Skipped prefetch unit of work index physical reads monitor element |
SKIPPED_PREFETCH_UOW_XDA_P_READS |
BIGINT |
skipped_prefetch_uow_xda_p_reads -
Skipped prefetch unit of work XDA data physical reads monitor element |
SKIPPED_PREFETCH_UOW_TEMP_DATA_P_READS |
BIGINT |
skipped_prefetch_uow_temp_data_p_reads
- Skipped prefetch unit of work temporary data physical reads monitor
element |
SKIPPED_PREFETCH_UOW_TEMP_INDEX_P_READS |
BIGINT |
skipped_prefetch_uow_temp_index_p_reads
- Skipped prefetch unit of work temporary index physical reads monitor
element |
SKIPPED_PREFETCH_UOW_TEMP_XDA_P_READS |
BIGINT |
skipped_prefetch_uow_temp_xda_p_reads
- Skipped prefetch unit of work temporary XDA data physical reads
monitor element |
PREFETCH_WAIT_TIME |
BIGINT |
prefetch_wait_time - Time waited for
prefetch |
PREFETCH_WAITS |
BIGINT |
prefetch_waits - Prefetcher wait count
monitor element |
POOL_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_data_gbp_indep_pages_found_in_lbp
- Group buffer pool independent data pages found in local buffer pool
monitor element |
POOL_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_index_gbp_indep_pages_found_in_lbp
- Group buffer pool independent index pages found in local buffer
pool monitor element |
POOL_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_xda_gbp_indep_pages_found_in_lbp
- Group buffer pool XDA independent pages found in local buffer pool
monitor element |
POOL_ASYNC_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_async_data_gbp_indep_pages_found_in_lbp
- Group buffer pool independent data pages found by asynchronous EDUs
in a local buffer pool monitor element monitor element |
POOL_ASYNC_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_async_index_gbp_indep_pages_found_in_lbp
- Group buffer pool independent index pages found by asynchronous
EDUs in a local buffer pool monitor element monitor element |
POOL_ASYNC_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_async_xda_gbp_indep_pages_found_in_lbp
- Group buffer pool independent XML storage object(XDA) pages found
by asynchronous EDUs in a local buffer pool monitor element monitor
element |
TBSP_NUM_CONTAINERS |
BIGINT |
tablespace_num_containers - Number
of Containers in Table Space |
TBSP_INITIAL_SIZE |
BIGINT |
tablespace_initial_size - Initial table
space size |
TBSP_MAX_SIZE |
BIGINT |
tablespace_max_size - Maximum table
space size |
TBSP_INCREASE_SIZE |
BIGINT |
tablespace_increase_size - Increase
size in bytes |
TBSP_INCREASE_SIZE_PERCENT |
SMALLINT |
tablespace_increase_size_percent -
Increase size by percent |
TBSP_LAST_RESIZE_TIME |
TIMESTAMP |
tablespace_last_resize_time - Time
of last successful resize |
TBSP_LAST_RESIZE_FAILED |
SMALLINT |
tablespace_last_resize_failed - Last
resize attempt failed |
POOL_COL_L_READS |
BIGINT |
pool_col_l_reads - Buffer pool column-organized
logical reads monitor element |
POOL_TEMP_COL_L_READS |
BIGINT |
pool_temp_col_l_reads - Buffer pool
column-organized temporary logical reads |
POOL_COL_P_READS |
BIGINT |
pool_col_p_reads - Buffer pool column-organized
physical reads |
POOL_TEMP_COL_P_READS |
BIGINT |
pool_temp_col_p_reads - Buffer pool
column-organized temporary physical reads monitor element |
POOL_COL_LBP_PAGES_FOUND |
BIGINT |
pool_col_lbp_pages_found - Buffer pool
column-organized LBP pages found monitor element |
POOL_COL_WRITES |
BIGINT |
pool_col_writes - Buffer pool column-organized
writes |
POOL_ASYNC_COL_READS |
BIGINT |
pool_async_col_reads - Buffer pool
asynchronous column-organized reads |
POOL_ASYNC_COL_READ_REQS |
BIGINT |
pool_async_col_read_reqs - Buffer pool
asynchronous column-organized read requests |
POOL_ASYNC_COL_WRITES |
BIGINT |
pool_async_col_writes - Buffer pool
asynchronous column-organized writes |
POOL_ASYNC_COL_LBP_PAGES_FOUND |
BIGINT |
pool_async_col_lbp_pages_found - Asynchronous
local buffer pool column-organized pages found |
POOL_COL_GBP_L_READS |
BIGINT |
pool_col_gbp_l_reads - Buffer pool
column-organized GBP logical reads |
POOL_COL_GBP_P_READS |
BIGINT |
pool_col_gbp_p_reads - Buffer pool
column-organized GBP physical reads |
POOL_COL_GBP_INVALID_PAGES |
BIGINT |
pool_col_gbp_invalid_pages - Buffer
pool column-organized GBP invalid data pages |
POOL_COL_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_col_gbp_indep_pages_found_in_lbp
- Buffer pool column-organized GBP independent pages found in local
buffer pool |
POOL_ASYNC_COL_GBP_L_READS |
BIGINT |
pool_async_col_gbp_l_reads - Asynchronous
group buffer pool column-organized logical reads |
POOL_ASYNC_COL_GBP_P_READS |
BIGINT |
pool_async_col_gbp_p_reads - Asynchronous
group buffer pool column-organized physical reads |
POOL_ASYNC_COL_GBP_INVALID_PAGES |
BIGINT |
pool_async_col_gbp_invalid_pages -
Asynchronous group buffer pool invalid data pages monitor element |
POOL_ASYNC_COL_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_async_col_gbp_indep_pages_found_in_lbp
- Asynchronous group buffer pool column-organized independent data
pages found in local buffer pool monitor element |
POOL_QUEUED_ASYNC_COL_REQS |
BIGINT |
pool_queued_async_col_reqs - Column-organized
prefetch requests |
POOL_QUEUED_ASYNC_TEMP_COL_REQS |
BIGINT |
pool_queued_async_temp_col_reqs - Column-organized
temporary prefetch requests |
POOL_QUEUED_ASYNC_COL_PAGES |
BIGINT |
pool_queued_async_col_pages - Column-organized
page prefetch requests |
POOL_QUEUED_ASYNC_TEMP_COL_PAGES |
BIGINT |
pool_queued_async_temp_col_pages -
Column-organized page temporary prefetch requests |
POOL_FAILED_ASYNC_COL_REQS |
BIGINT |
pool_failed_async_col_reqs - Failed
column-organized prefetch requests |
POOL_FAILED_ASYNC_TEMP_COL_REQS |
BIGINT |
pool_failed_async_temp_col_reqs - Failed
column-organized temporary prefetch requests |
SKIPPED_PREFETCH_COL_P_READS |
BIGINT |
skipped_prefetch_col_p_reads - Skipped
prefetch column-organized physical reads |
SKIPPED_PREFETCH_TEMP_COL_P_READS |
BIGINT |
skipped_prefetch_temp_col_p_reads -
Skipped prefetch column-organized temporary physical reads |
SKIPPED_PREFETCH_UOW_COL_P_READS |
BIGINT |
skipped_prefetch_uow_col_p_reads -
Skipped prefetch unit of work column-organized physical reads |
SKIPPED_PREFETCH_UOW_TEMP_COL_P_READS |
BIGINT |
skipped_prefetch_uow_temp_col_p_reads
- Skipped prefetch unit of work column-organized temporary physical
reads |
TBSP_NUM_QUIESCERS |
BIGINT |
tablespace_num_quiescers |
TBSP_NUM_RANGES |
BIGINT |
tablespace_num_ranges |
CACHING_TIER |
VARCHAR(8) |
Reserved for future use. |
POOL_DATA_CACHING_TIER_L_READS |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_L_READS |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_L_READS |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_L_READS |
BIGINT |
Reserved for future use. |
POOL_DATA_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_DATA_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_CACHING_TIER_PAGE_READ_TIME |
BIGINT |
Reserved for future use. |
POOL_CACHING_TIER_PAGE_WRITE_TIME |
BIGINT |
Reserved for future use. |
POOL_DATA_CACHING_TIER_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_DATA_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_DATA_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_ASYNC_DATA_CACHING_TIER_READS |
BIGINT |
Reserved for future use. |
POOL_ASYNC_INDEX_CACHING_TIER_READS |
BIGINT |
Reserved for future use. |
POOL_ASYNC_XDA_CACHING_TIER_READS |
BIGINT |
Reserved for future use. |
POOL_ASYNC_COL_CACHING_TIER_READS |
BIGINT |
Reserved for future use. |
POOL_ASYNC_DATA_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_INDEX_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_XDA_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_COL_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_DATA_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_INDEX_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_XDA_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_COL_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_DATA_CACHING_TIER_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_ASYNC_INDEX_CACHING_TIER_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_ASYNC_XDA_CACHING_TIER_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_ASYNC_COL_CACHING_TIER_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_ASYNC_DATA_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_INDEX_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_XDA_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_COL_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_ASYNC_DATA_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_ASYNC_INDEX_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_ASYNC_XDA_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_ASYNC_COL_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
LOB_PREFETCH_WAIT_TIME |
BIGINT |
lob_prefetch_wait_time - LOB prefetch wait time monitor element |
LOB_PREFETCH_REQS |
BIGINT |
lob_prefetch_reqs - LOB prefetcher request count monitor element |