oracle11g自动统计数据收集?
时间:2011-09-02
来源:互联网
请问各位:在oracle11g中关于自动统计数据收集的这些job的具体用途是什么?为什么与oracle10g的不一样?
1 SELECT log_id, job_name, status,
2 TO_CHAR (log_date, 'YYYY-MM-DD HH24:MI') log_date
3 FROM dba_scheduler_job_run_details
4 WHERE job_name
5 like 'ORA%'
6* order by log_date
26060 ORA$AUTOTASK_CLEAN SUCCEEDED 2011-08-27 03:00
26080 ORA$AT_SQ_SQL_SW_3909 SUCCEEDED 2011-08-27 06:00
26083 ORA$AT_SA_SPC_SY_3908 SUCCEEDED 2011-08-27 06:00
26086 ORA$AT_OS_OPT_SY_3907 SUCCEEDED 2011-08-27 06:01
26103 ORA$AT_SA_SPC_SY_3911 SUCCEEDED 2011-08-27 10:02
26107 ORA$AT_OS_OPT_SY_3910 SUCCEEDED 2011-08-27 10:12
26140 ORA$AT_SA_SPC_SY_3925 SUCCEEDED 2011-08-27 14:02
26143 ORA$AT_OS_OPT_SY_3924 SUCCEEDED 2011-08-27 14:04
26160 ORA$AT_SA_SPC_SY_3927 SUCCEEDED 2011-08-27 18:01
26163 ORA$AT_OS_OPT_SY_3926 SUCCEEDED 2011-08-27 18:02
26183 ORA$AT_OS_OPT_SY_3928 SUCCEEDED 2011-08-27 22:01
LOG_ID JOB_NAME STATUS LOG_DATE
---------- ------------------------- ------------------------------ ----------------
26180 ORA$AT_SA_SPC_SY_3929 SUCCEEDED 2011-08-27 22:01
26200 ORA$AUTOTASK_CLEAN SUCCEEDED 2011-08-28 03:00
26220 ORA$AT_SA_SPC_SY_3931 SUCCEEDED 2011-08-28 06:00
26223 ORA$AT_SQ_SQL_SW_3932 SUCCEEDED 2011-08-28 06:00
26226 ORA$AT_OS_OPT_SY_3930 SUCCEEDED 2011-08-28 06:01
1 SELECT log_id, job_name, status,
2 TO_CHAR (log_date, 'YYYY-MM-DD HH24:MI') log_date
3 FROM dba_scheduler_job_run_details
4 WHERE job_name
5 like 'ORA%'
6* order by log_date
26060 ORA$AUTOTASK_CLEAN SUCCEEDED 2011-08-27 03:00
26080 ORA$AT_SQ_SQL_SW_3909 SUCCEEDED 2011-08-27 06:00
26083 ORA$AT_SA_SPC_SY_3908 SUCCEEDED 2011-08-27 06:00
26086 ORA$AT_OS_OPT_SY_3907 SUCCEEDED 2011-08-27 06:01
26103 ORA$AT_SA_SPC_SY_3911 SUCCEEDED 2011-08-27 10:02
26107 ORA$AT_OS_OPT_SY_3910 SUCCEEDED 2011-08-27 10:12
26140 ORA$AT_SA_SPC_SY_3925 SUCCEEDED 2011-08-27 14:02
26143 ORA$AT_OS_OPT_SY_3924 SUCCEEDED 2011-08-27 14:04
26160 ORA$AT_SA_SPC_SY_3927 SUCCEEDED 2011-08-27 18:01
26163 ORA$AT_OS_OPT_SY_3926 SUCCEEDED 2011-08-27 18:02
26183 ORA$AT_OS_OPT_SY_3928 SUCCEEDED 2011-08-27 22:01
LOG_ID JOB_NAME STATUS LOG_DATE
---------- ------------------------- ------------------------------ ----------------
26180 ORA$AT_SA_SPC_SY_3929 SUCCEEDED 2011-08-27 22:01
26200 ORA$AUTOTASK_CLEAN SUCCEEDED 2011-08-28 03:00
26220 ORA$AT_SA_SPC_SY_3931 SUCCEEDED 2011-08-28 06:00
26223 ORA$AT_SQ_SQL_SW_3932 SUCCEEDED 2011-08-28 06:00
26226 ORA$AT_OS_OPT_SY_3930 SUCCEEDED 2011-08-28 06:01
作者: pingpang81 发布时间: 2011-09-02
upupup
作者: qunyking 发布时间: 2011-09-03
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28