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开始引入的自动统计数据收集功能的重要组成部分,但是这个定时任务带来的问题...【阅读全文】
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收集统计信息时建议...【阅读全文】
Beginning
with Oracle10G, when statistics are gathered for a table, the old statistics are
retained so should there be any problem with performance of queries dependent
on those statistics, the old ones can be restored.How
long does Oracle retain the statistics for ?
The
default peri【阅读全文】