Lin Hong's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle 19c 21c parameter different Tips

2021-08-14

Oracle 19c 21c parameter different Tips

19c and 21c parameters diff

parameters

parameters

 

hidden parameters between 19c and 21c

hidden parameters

 

The Persistent Memory Database feature includes directly mapped buffer cache and Persistent Memory Filestore (PMEM Filestore).

Persistent Memory Database feature should be very much expected to be applied.

  • PMEM_FILESTORE

2.289 PMEM_FILESTORE

mount_point: The operating system directory path for the mount point of the PMEM Filestore

backing_file: The operating system file path for the backing file of the PMEM Filestore

9.125 V$PMEM_FILESTORE

16.3 Creating a PMEM Filestore for an Oracle Database

Other pmem hidden parameters:

__db_pmem_direct_map_size_metadata
_db_cache_pmem_confidence_try
_db_cache_pmem_promotion_touch_rate_reset_interval
_db_cache_pmem_promotion_touch_rate_threshold_time
_db_cache_pmem_touch_rate_compare_per
_db_cache_pmemp_len
_db_pmem_auto_resize_interval
_db_pmem_direct_map_siz
_direct_io_via_mapped_pmem
_enable_pmem_direct_cache
_enable_pmem_exchange
_enable_pmem_prefetch
_exa_pmemlog_threshold_usec
_force_pmem_direct_mapped_cache_scan
_pmem_exchange_cold_victim_threshold
_pmem_small_table_threshold
_pmemfs_alloc_dataptrs
_pmemfs_enable_spacetracking
_pmemfs_shrink_level
_pmemfs_smallfile_threshold

Have a good work&life! 2021/08 via LinHong


Similar Posts

Comments