Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1168387
  • 博文数量: 178
  • 博客积分: 2776
  • 博客等级: 少校
  • 技术积分: 2809
  • 用 户 组: 普通用户
  • 注册时间: 2012-03-22 15:36
文章分类

全部博文(178)

文章存档

2014年(3)

2013年(66)

2012年(109)

发布时间: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.但是,.........【阅读全文】

阅读(2022) | 评论(0) | 转发(0)

发布时间: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 .........【阅读全文】

阅读(4746) | 评论(0) | 转发(0)

发布时间: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.........【阅读全文】

阅读(3933) | 评论(0) | 转发(0)

发布时间: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.........【阅读全文】

阅读(1768) | 评论(0) | 转发(0)

发布时间: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 .........【阅读全文】

阅读(1021) | 评论(0) | 转发(0)
给主人留下些什么吧!~~

woshiginus2013-06-17 10:43

发现好东西了,呵呵!楼主学习下!

回复  |  举报

saintli862012-11-30 13:01

好东西不少,我要常来学习!

回复  |  举报

云中的二舅2012-07-27 14:18

欢迎大家给我留言

回复  |  举报
留言热议
请登录后留言。

登录 注册