oracle seq_task,Oracle 11G 统计信息Task

Wed Aug 21 11:30:00 2013

Setting Resource Manager plan SCHEDULER[0x3109]:DEFAULT_MAINTENANCE_PLAN

via scheduler window

Setting Resource Manager plan

DEFAULT_MAINTENANCE_PLAN via parameter

Wed Aug 21 11:30:00 2013

Starting background process VKRM

Wed Aug 21 11:30:00 2013

VKRM started with pid=52, OS id=6382

Wed Aug 21 11:30:02 2013

Begin automatic SQL Tuning Advisor run

for special tuning task

"SYS_AUTO_SQL_TUNING_TASK"

Wed Aug 21 11:30:24 2013

DBMS_STATS: GATHER_STATS_JOB encountered

errors.  Check the trace file.

Errors in file

/u01/app/oracle/diag/rdbms/eabudb/eabudb/trace/eabudb_j000_6391.trc:

ORA-20011:

Approximate NDV failed: ORA-06564: object DMP does not exist

Wed Aug 21 11:32:47 2013

Thread 1 cannot allocate new log,

sequence 734

Private strand flush not complete

Current log# 4 seq# 733 mem# 0: /u01/app/oracle/oradata/eabudb/redo04.log

Thread 1 advanced to log sequence 734

(LGWR switch)

Current log# 5 seq# 734 mem# 0:

/u01/app/oracle/oradata/eabudb/redo05.log

Wed Aug 21 11:32:51 2013

Archived Log entry 1303 added for thread

1 sequence 733 ID 0x59630e1f dest 1:

Wed Aug 21 11:34:18 2013

End automatic SQL Tuning Advisor run for

special tuning task

"SYS_AUTO_SQL_TUNING_TASK"

Wed Aug 21 12:14:28 2013

Thread 1 advanced to log sequence 735

(LGWR switch)

Current log# 1 seq# 735 mem# 0: /u01/app/oracle/oradata/eabudb/redo01.log

Wed Aug 21 12:14:28 2013

Archived Log entry 1305 added for thread

1 sequence 734 ID 0x59630e1f dest 1:

Wed Aug 21 13:12:59 2013

Time drift detected. Please check VKTM

trace file for more details.

Wed Aug 21 13:29:33 2013

Thread 1 advanced to log sequence 736

(LGWR switch)

Current log# 2 seq# 736 mem# 0:

/u01/app/oracle/oradata/eabudb/redo02.log

Wed Aug 21 13:29:34 2013

Archived Log entry 1307 added for thread

1 sequence 735 ID 0x59630e1f dest 1:

Wed Aug 21 14:43:17 2013

Thread 1 advanced to log sequence 737

(LGWR switch)

Current log# 3 seq# 737 mem# 0:

/u01/app/oracle/oradata/eabudb/redo03.log

Wed Aug 21 14:43:18 2013

Archived Log entry 1309 added for thread

1 sequence 736 ID 0x59630e1f dest 1:

Wed Aug 21 15:30:00 2013

Closing scheduler window

Closing Resource Manager plan via

scheduler window

Clearing Resource Manager plan via

parameter