Oracle 查看自带的Job,可以使用select * from Dba_Scheduler_Jobs;10G中,GATHER_STATS_JOB这个自动任务默认情况下在工作日22:00-6:00和周末全天开启。http://www.eygle.com/archives/2009/09/gather_stats_job.htmlGATHER_STATS_JOB是10g开始引入的自动统计数据收集功能的重要组成部分,但是这个定时任务带来的问题...【阅读全文】
并不是用了绑定变量就一定都会游标共享,下面我们介绍的就是一种例子。BIND_MISMATCH导致VERSION COUNT过多的原因解释:This is due to the bind buffer mismatch of the current child cursor. If oracle is unable to bind the current value to the existing child cursors bind buffer, oracle upg...【阅读全文】
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.但是,...【阅读全文】