刚startup后负载很高这种问题怎么解决呀

feijizjh

你们的意思简单说是不是充许程序连接前先把常所有的查询先查一遍，让他在内存当中可以找到，对吗？delete和UPDATE呢？

feijizjh

太多sql语句了，不可能全部执行一次吧，有没有其它更好办法呢》？

Yong Huang

feijizjh, I said queries only. If you have deletes and updates, just run queries against the tables the deletes and updates reference. If you really want, you can also run the deletes and updates and immediately rollback. You didn't seem to get the point. The point is to bring the blocks into buffer cache. We don't care what the actual SQLs are like. If you have too many SQLs, just pick a few tables that are referenced often in those SQLs.

viadeazhu, I agree it's a good idea to let the app warm up the buffer cache. The great philosopher Zhuang Zi said "Do nothing and nothing is left undone!" But it's possible that the users expect to come to office in the morning and start to work expecting immediate response even at the beginning. If so, DBAs can do something to make them happier. Otherwise, hire a low-wage secretary to go through some typical screens of the app very early in the morning, before the VIP users come in. Otherwise, just configure keep cache and throw frequently used tables into it.

Before we make such suggestions, can we make sure the frequently run SQLs are all tuned?

Yong Huang

kewin

Why the oracle  so frequently bounce?
I means if the db is only shutdown and open once in half a year, this question maybe is not real problem.

feijizjh

也不是这样的，我们公司是互连网公司，经常因为机房当网或其它原困要切换DATAGUARD，所以不是开起半年一年才STARTUP，谢谢大家的指教!