buffer cache 的调整与优化(一)（缓冲区缓存的调整与优化（一））.doc

buffer cache 的调整与优化(一)（缓冲区缓存的调整与优化（一）） Adjustment and optimization of Buffer cache (Part 1) Personal classification: Oracle Performance Tuning Adjustment and optimization of Buffer cache (Part 1) Classification: Oracle performance optimization --============================== Adjustment and optimization of Buffer cache (Part 1) --============================== Buffer Cache is an important component of SGA, which is mainly used to cache data blocks, and its size also directly affects the performance of the system. When Buffer Cache is too small, will cause more Free buffer waits event. The following detailed description of Buffer Cache function, adjustment and optimization. First, all the components of SGA The relevant information was obtained from the SGA dynamic view v$sga_dynamic_components SELECTcomponent, current_size, min_sizeFROMv$sga_dynamic_components; COMPONENT CURRENT_SIZE MIN_SIZE Shared pool 7130316871303168 Large pool 41943044194304 Java pool 41943044194304 Streams pool 41943044194304 DEFAULTbuffer cache 113246208113246208 KEEP buffer cache 00 RECYCLE buffer cache 00 DEFAULT2K buffer cache 00 DEFAULT4K buffer cache 00 DEFAULT8K buffer cache 00 DEFAULT16K buffer cache 00 DEFAULT32K buffer cache 00 ASM Buffer Cache 00 Two, Buffer cache introduction The types of 1.Buffer cache usually include Default buffer cache Keep buffer cache Recycle buffer cache NK buffer caches The background process for dealing with Buffer cache is DBWn, and the corresponding data files are usually located in SYSTEM tablespace, sysaux tablespace, undo tablespace, datafile, etc. Buffer cache is a part of SGA, which is a data block read by the user process from the data file, and all users share these data blocks. Usually, service The process is to improve the performance of I/O, will be a one-time reading a plurality of data blocks. Buffer cache for dirty data is written to the data file DBWn process. Similarly, to improve performance, DBWn The process also writes multiple data bloc