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_TEMP_DATA_CACHING_TIER_L_READS |
BIGINT |
pool_temp_data_caching_tier_l_reads - pool temporary
data page caching tier l reads monitor element |
POOL_TEMP_DATA_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_temp_data_caching_tier_pages_found - Buffer pool
temporary data pages found in caching tier monitor element |
POOL_XDA_L_READS |
BIGINT |
pool_xda_l_reads - Buffer pool XDA data logical
reads
|
POOL_TEMP_XDA_CACHING_TIER_L_READS |
BIGINT |
pool_temp_xda_caching_tier_l_reads - pool XML data-type
page caching tier l reads monitor element |
POOL_TEMP_XDA_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_temp_xda_caching_tier_pages_found - pool temporary
XML data-type tier pages found monitor element |
POOL_TEMP_XDA_L_READS |
BIGINT |
pool_temp_xda_l_reads - Buffer pool temporary XDA data
logical reads
|
POOL_TEMP_INDEX_CACHING_TIER_L_READS |
BIGINT |
pool_temp_index_caching_tier_l_reads - pool temporary
index-type page caching tier l reads monitor element |
POOL_TEMP_INDEX_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_temp_index_caching_tier_pages_found - pool
temporary index-type tier pages found monitor element |
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_TEMP_COL_CACHING_TIER_L_READS |
BIGINT |
pool_temp_col_caching_tier_l_reads - pool temporary
columnar-type page caching tier l reads monitor element |
POOL_TEMP_COL_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_temp_col_caching_tier_pages_found - pool temporary
columnar-type tier pages found monitor element |
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_CACHING_TIER_PAGE_READ_TIME |
BIGINT |
pool_async_caching_tier_page_read_time - Buffer pool
caching tier page read time monitor element |
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) |
caching_tier - Configuring table space multi-level
cache monitor element |
POOL_DATA_CACHING_TIER_L_READS |
BIGINT |
pool_data_caching_tier_l_reads - pool data caching tier
l reads monitor element |
POOL_INDEX_CACHING_TIER_L_READS |
BIGINT |
pool_index_caching_tier_l_reads - pool index caching
tier l reads monitor element |
POOL_XDA_CACHING_TIER_L_READS |
BIGINT |
pool_xda_caching_tier_l_reads - pool XML data caching
tier l reads monitor element |
POOL_COL_CACHING_TIER_L_READS |
BIGINT |
pool_col_caching_tier_l_reads - pool column data
caching tier l reads monitor element |
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 |
pool_caching_tier_page_read_time - pool caching tier
page read time monitor element |
POOL_CACHING_TIER_PAGE_WRITE_TIME |
BIGINT |
Reserved for future use. |
POOL_DATA_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_data_caching_tier_pages_found - Buffer pool data
caching tier pages found monitor element |
POOL_INDEX_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_index_caching_tier_pages_found - Buffer pool index
caching tier pages found monitor element |
POOL_XDA_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_xda_caching_tier_pages_found - Buffer pool XML
data caching tier pages found monitor element |
POOL_COL_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_col_caching_tier_pages_found - Buffer pool
columnar-type caching tier pages found monitor element |
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 |
pool_async_data_caching_tier_reads - Buffer pool
asynchronous data-type caching tier page reads |
POOL_ASYNC_INDEX_CACHING_TIER_READS |
BIGINT |
pool_async_index_caching_tier_reads - Buffer pool
asynchronous index-type caching tier page reads |
POOL_ASYNC_XDA_CACHING_TIER_READS |
BIGINT |
pool_async_xda_caching_tier_reads - Buffer pool
asynchronous XML data-type caching tier page reads |
POOL_ASYNC_COL_CACHING_TIER_READS |
BIGINT |
pool_async_col_caching_tier_reads - Buffer pool
asynchronous columnar-type caching tier page reads |
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 |
pool_async_data_caching_tier_pages_found - Buffer pool
asynchronous data caching tier pages found |
POOL_ASYNC_INDEX_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_async_index_caching_tier_pages_found - Buffer pool
asynchronous index caching tier pages found |
POOL_ASYNC_XDA_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_async_xda_caching_tier_pages_found - Buffer pool
asynchronous XML caching tier pages found |
POOL_ASYNC_COL_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_async_col_caching_tier_pages_found - Buffer pool
asynchronous columnar caching tier pages found |
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 |
CACHING_TIER_DIRECT_READS |
BIGINT |
caching_tier_direct_reads - Direct reads from caching
tier monitor element |
CACHING_TIER_DIRECT_READ_REQS |
BIGINT |
caching_tier_direct_read_reqs - Cache direct read
requests monitor element |
CACHING_TIER_DIRECT_READ_TIME |
BIGINT |
caching_tier_direct_read_time - Cache direct read time
monitor element |
CACHING_TIER_WRITE_BYTES |
BIGINT |
caching_tier_write_bytes - Bytes for write requests to
local tier monitor element |
CACHING_TIER_WRITE_REQS |
BIGINT |
caching_tier_write_reqs - Write requests to local cache
monitor element |
CACHING_TIER_WRITE_TIME |
BIGINT |
caching_tier_write_time - Elapsed time for write
requests monitor element |
COMPACTION_READ_BYTES |
BIGINT |
compaction_read_bytes - Bytes read during compaction
monitor element |
COMPACTION_READ_REQS |
BIGINT |
compaction_read_reqs - Read requests for compaction
monitor element |
COMPACTION_READ_TIME |
BIGINT |
compaction_read_time - Elapsed time to read during
compaction monitor element |
COMPACTION_WRITE_BYTES |
BIGINT |
compaction_write_bytes - Bytes written during
compaction monitor element |
COMPACTION_WRITE_REQS |
BIGINT |
compaction_write_reqs - Write request during compaction
monitor element |
COMPACTION_WRITE_TIME |
BIGINT |
compaction_write_time - Elapsed time to write during
compaction monitor element |
LOCAL_TIER_WRITE_BYTES |
BIGINT |
local_tier_write_bytes - Bytes to write to local tier
monitor element |
LOCAL_TIER_WRITE_REQS |
BIGINT |
local_tier_write_reqs - Write request for local tier
monitor element |
LOCAL_TIER_WRITE_TIME |
BIGINT |
local_tier_write_time - Elapsed time to write monitor
element |
REMOTE_STORAGE_TIER_WRITE_BYTES |
BIGINT |
remote_storage_tier_write_bytes - Bytes to write to
remote storage tier monitor element |
REMOTE_STORAGE_TIER_WRITE_REQS |
BIGINT |
remote_storage_tier_write_reqs - Write requests to
remote storage monitor element |
REMOTE_STORAGE_TIER_WRITE_TIME |
BIGINT |
remote_storage_tier_write_time - Elapsed time to write
to remote storage monitor element |