col job_name format a30
col LAST_START_DATe format a40
select job_name,last_start_date from dba_scheduler_jobs
JOB_NAME LAST_START_DATE
------------------------------ ----------------------------------------
AUTO_SPACE_ADVISOR_JOB 29-NOV-10 10.00.02.408609 PM +08:00
GATHER_STATS_JOB 29-NOV-10 10.00.02.442664 PM +08:00
FGR$AUTOPURGE_JOB
PURGE_LOG 30-NOV-10 03.00.00.143774 AM ASIA/TAIPEI
MGMT_STATS_CONFIG_JOB 01-NOV-10 01.01.02.003099 AM +08:00
MGMT_CONFIG_JOB 29-NOV-10 10.00.02.520259 PM +08:00
RLM$SCHDNEGACTION 30-NOV-10 02.02.00.099177 PM +08:00
RLM$EVTCLEANUP 30-NOV-10 02.01.22.163359 PM +08:00
8 rows selected.
关闭及开启自动搜集功能,有两种方法,分别如下:
方法一:
exec dbms_scheduler.disable('SYS.GATHER_STATS_JOB');
exec dbms_scheduler.enable('SYS.GATHER_STATS_JOB');
方法二:
alter system set "_optimizer_autostats_job"=false scope=spfile;
alter system set "_optimizer_autostats_job"=true scope=spfile;
[@more@]参考:http://www.eygle.com/archives/2009/09/gather_stats_job.html
http://asdic.javaeye.com/blog/325667
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/789833/viewspace-1042365/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/789833/viewspace-1042365/