通常,如果缓存的命中率太低可以增大缓存的大小和避免你的应用程序执行全表扫描.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_ADVICE view to determine the next increm...【阅读全文】
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 ...【阅读全文】
设置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...【阅读全文】
一.查看产生的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 ...【阅读全文】
oracle 教程http://www.cuug.com/一.SQL*PLUS中输入SQL> conn as sysdba;SQL> alter system setjob_queue_processes = 6; --自动执行数据收集时该参数需要大于0SQL> alter system set timed_statistics =true; --使用statspack收集统计信息时建议...【阅读全文】