发布时间:2013-02-25 09:52:57
However, increasing the cache size to 334MB would potentially decrease reads by a factor of .93 or 7%. If an additional 30MB memory is available on the host system and theSGA_MAX_SIZE setting allows the increment, it would be advisable to increase the default buffer cache pool size to 334MB.但是,.........【阅读全文】
发布时间:2013-02-22 10:53:12
7.2.2.1 Buffer Cache Advisory StatisticsA number of statistics can be used to examine buffer cache activity. These include the following:V$DB_CACHE_ADVICEBuffer cache hit ratiobuffer cache 报告的统计统计的数据能被用于检查buffer cache的活动。7.2.2.2 Using V$DB_CACHE_ADVICEThis view is .........【阅读全文】
发布时间:2013-02-21 09:51:13
设置db_cache_advice的初始参数, 动态调整buffer pool的大小To increase cache size, first set the DB_CACHE_ADVICE initialization parameter toON, and let the cache statistics stabilize. Examine the advisory data in theV$DB_CACHE_ADVICEview to determine the next increment required to significantly dec.........【阅读全文】
发布时间:2013-02-20 09:25:01
To interpret the buffer cache hit ratio,you should consider the following:解释缓存的命中率,你应该解释如下:Repeated scanning of the same large tableor index can artificially inflate a poor cache hit ratio. Examine frequentlyexecuted SQL statements with a large number of b.........【阅读全文】
发布时间:2013-02-19 09:31:21
一.查看产生的report1文档C:\oracle\ora92\bin\report1.txt二.自动执行STATSPACK收集统计信息SQL>@C:\oracle\ora92\rdbms\admin\spauto.sql;Job number for automated statistics collection for this instance~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Note that this job number is .........【阅读全文】