重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 查看ORACLE自动统计信息收集的自动任务的执行时间 [打印本页]

作者: 郑全 时间: 4 天前
标题: 查看ORACLE自动统计信息收集的自动任务的执行时间

SYS@windba1> SELECT client_name, job_status,  JOB_START_TIME, JOB_DURATION
            FROM dba_autotask_job_history
            order by JOB_START_TIME desc
         FETCH FIRST 20 ROWS ONLY;

CLIENT_NAME                            JOB_STATUS                   JOB_START_TIME
---------------------------------------- ------------------------------ ---------------------------------------------------------------------------
JOB_DURATION
---------------------------------------------------------------------------
auto optimizer stats collection       SUCCEEDED                   09-5月 -26 10.00.59.099628 上午 PRC
+000 00:03:14

auto optimizer stats collection       SUCCEEDED                   09-5月 -26 06.00.02.208028 上午 PRC
+000 00:04:42

auto optimizer stats collection       SUCCEEDED                   08-5月 -26 10.00.02.228854 下午 PRC
+000 00:51:47

CLIENT_NAME                            JOB_STATUS                   JOB_START_TIME
---------------------------------------- ------------------------------ ---------------------------------------------------------------------------
JOB_DURATION
---------------------------------------------------------------------------
auto optimizer stats collection       SUCCEEDED                   07-5月 -26 10.00.01.641839 下午 PRC
+000 00:55:46

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)