神之一招

摘要： Buffer Cache 特性The buffer cache holds copies of the data blocks from the data files. Because the buffer cache is a part of the SGA, these blocks can be shared by all users. The server processes read data from the data files into buffer cache.(是server process 将数据从硬盘读取到内存的) To improve performance, the 阅读全文

摘要： Shared Pool Tuning目标是提高命中率, 以减少 I/O 操作shared pool : 是由 library cache, data dictionary cache 两部分组成. 由于 data dictionary cache 在内存中的时间比 library cache 时间长... 阅读全文