ITPub博客

首页 > Linux操作系统 > Linux操作系统 > DBMS_STATS.PLAN

DBMS_STATS.PLAN

原创 Linux操作系统 作者:ygzhou518 时间:2012-05-09 14:07:06 0 删除 编辑
Thread 1 cannot allocate new log, sequence 4097
Checkpoint not complete
  Current log# 1 seq# 4096 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo01.log
Thread 1 advanced to log sequence 4097 (LGWR switch)
  Current log# 2 seq# 4097 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo02.log
Tue May 08 21:32:41 2012
Starting background process CJQ0
Tue May 08 21:32:41 2012
WARNING: process CJQ0 (ospid: 14508) was unable to attach SMR.
Errors in file /u01/app/oracle/diag/rdbms/ygzhou01/ygzhou01/trace/ygzhou01_cjq0_14508.trc:
ORA-27300: OS system dependent operation:open failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sskgmsmr_7
CJQ0 started with pid=22, OS id=14508 
Tue May 08 22:00:00 2012
Setting Resource Manager plan SCHEDULER[0x3108]:DEFAULT_MAINTENANCE_PLAN via scheduler wind
ow
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Tue May 08 22:00:00 2012
Starting background process VKRM
Tue May 08 22:00:00 2012
WARNING: process VKRM (ospid: 28686) was unable to attach SMR.
Errors in file /u01/app/oracle/diag/rdbms/ygzhou01/ygzhou01/trace/ygzhou01_vkrm_28686.trc:
ORA-27300: OS system dependent operation:open failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sskgmsmr_7
VKRM started with pid=21, OS id=28686 
Tue May 08 22:00:06 2012
WARNING: process USER (ospid: 28706) was unable to attach SMR.
Errors in file /u01/app/oracle/diag/rdbms/ygzhou01/ygzhou01/trace/ygzhou01_j001_28706.trc:
ORA-27300: OS system dependent operation:open failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sskgmsmr_7
Tue May 08 22:00:08 2012
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Tue May 08 22:00:12 2012
DBMS_STATS: GATHER_STATS_JOB encountered errors.  Check the trace file.
Errors in file /u01/app/oracle/diag/rdbms/ygzhou01/ygzhou01/trace/ygzhou01_j002_28708.trc:
ORA-20011: Approximate NDV failed: ORA-06564: object YGZHOU does not exist
Tue May 08 22:01:19 2012
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Tue May 08 23:00:47 2012
Thread 1 advanced to log sequence 4098 (LGWR switch)
  Current log# 3 seq# 4098 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo03.log
Wed May 09 00:02:52 2012
Thread 1 advanced to log sequence 4099 (LGWR switch)
  Current log# 1 seq# 4099 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo01.log
Wed May 09 02:00:00 2012
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Wed May 09 03:12:52 2012
Stopping background process CJQ0
Wed May 09 09:01:01 2012
Thread 1 advanced to log sequence 4100 (LGWR switch)
  Current log# 2 seq# 4100 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo02.log
Wed May 09 09:44:23 2012

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24867586/viewspace-723131/,如需转载,请注明出处,否则将追究法律责任。

上一篇: DBMS_STATS
下一篇: Oracle Files
请登录后发表评论 登录
全部评论

注册时间:2011-02-11

  • 博文量
    167
  • 访问量
    364615