检查是否有频繁的全表扫描,导致数据替换出数据高速缓存将经常使用的小表,加cache属性,将其数据保存到缓存中,避免换出
解决方案 »
- 请问这个程序有错吗,关于外键的
- oracle和excel数据互导的问题?
- 有没有一句SQL语句,可以把我一个用户下所有的表结构复制到另一个用户下,只要表结构,不需要数据
- 当是二行数据时,如何求出平均值,当是一行时就无须求平均值
- 如何得知某个字段比如(u_id)都在哪些表中。
- 关于定时作业,以及对数据库的影响
- 在一表中有一日期型字段,有数百条记录,日期格式为2004-4-10 12:20:19形式,怎么写SQL把日期改成2004-4-10形式
- 菜鸟问题, 搞定就给分。
- ORA-06519: active autonomous transaction detected and rolled back
- 在戴尔服务器上装orale Linux 6.4,然后再装oracle 11g R2,
- 请教,数据导出的问题!
- ORACLE中如何把SQL查询结果自动写入一个文本文件中,请指点~!
do like this:
ALTER TABLE little CACHE;
去掉cache属性:
ALTER TABLE little NOCACHE
--------------------------------------------------------------------------------
Subject: Re: How to tune the memory? Author: Michel Cadot, France Date: Feb 01, 2004, 19 hours ago Score: Message: Hi, My 2 cents to add something to good answer from Shailandra. Do you have any response time probem? If not, don't worry about hit ratio or others? If you have some performance issue, before statspack verify that you are not swapping. And with statspack, before analyzing all SQL statements to reduce LIO, take a look at the wait section of statspack report. It shows you where Oracle waits. May be this is not LIO but switch log too often, dbwr too slow, file I/O too slow, access to same block, contention on header... the waiting events show where are the bottlenecks. Have also a look at hard parses ratio (-> not use of bind variables), recursive call ratio (-> dictionary cache too small)... Remember to set timed_statistics to true before running statspack. Regards
Michel
存储过程是一个日结处理过程,每天统计每种商品(两万种商品)的销售异动.
所以要频繁的扫描销售明细表(五百万条记录).
当销售明细表超过三百万条记录时,日结处理速度变慢.有什么好的建议吗?