Mon Aug 17 00:11:56 2009
Thread 1 advanced to log sequence 1123
Current log# 1 seq# 1123 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo1
Mon Aug 17 02:00:00 2009
Clearing Resource Manager plan via parameter
Mon Aug 17 02:52:03 2009
Thread 1 advanced to log sequence 1124
Current log# 2 seq# 1124 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo2
Mon Aug 17 05:00:09 2009
Stopping background process CJQ0
Mon Aug 17 09:11:20 2009
Thread 1 advanced to log sequence 1125
Current log# 3 seq# 1125 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo3
Mon Aug 17 15:34:10 2009
Thread 1 advanced to log sequence 1126
Current log# 1 seq# 1126 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo1
Mon Aug 17 20:02:23 2009
Starting background process CJQ0
Mon Aug 17 20:02:23 2009
CJQ0 started with pid=172, OS id=12844
Mon Aug 17 20:18:09 2009
Stopping background process CJQ0
Mon Aug 17 21:29:53 2009
Thread 1 advanced to log sequence 1127
Current log# 2 seq# 1127 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo2
Mon Aug 17 21:32:42 2009
Starting background process CJQ0
Mon Aug 17 21:32:42 2009
CJQ0 started with pid=135, OS id=22410
Mon Aug 17 22:00:00 2009
Setting Resource Manager plan SCHEDULER[0x2C09]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Mon Aug 17 22:00:02 2009
星期一 8月 17 22:00:02 2009
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownSCN) is 154290331
Mon Aug 17 22:00:02 2009
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Mon Aug 17 22:00:19 2009
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Mon Aug 17 23:47:30 2009
Thread 1 advanced to log sequence 1128
Current log# 3 seq# 1128 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo3
Tue Aug 18 01:32:02 2009
Thread 1 advanced to log sequence 1129
Current log# 1 seq# 1129 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo1
Tue Aug 18 02:00:00 2009
Clearing Resource Manager plan via parameter
Tue Aug 18 03:14:00 2009
Stopping background process CJQ0
Tue Aug 18 07:48:51 2009
Thread 1 advanced to log sequence 1130
Current log# 2 seq# 1130 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo2
Thread 1 advanced to log sequence 1123
Current log# 1 seq# 1123 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo1
Mon Aug 17 02:00:00 2009
Clearing Resource Manager plan via parameter
Mon Aug 17 02:52:03 2009
Thread 1 advanced to log sequence 1124
Current log# 2 seq# 1124 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo2
Mon Aug 17 05:00:09 2009
Stopping background process CJQ0
Mon Aug 17 09:11:20 2009
Thread 1 advanced to log sequence 1125
Current log# 3 seq# 1125 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo3
Mon Aug 17 15:34:10 2009
Thread 1 advanced to log sequence 1126
Current log# 1 seq# 1126 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo1
Mon Aug 17 20:02:23 2009
Starting background process CJQ0
Mon Aug 17 20:02:23 2009
CJQ0 started with pid=172, OS id=12844
Mon Aug 17 20:18:09 2009
Stopping background process CJQ0
Mon Aug 17 21:29:53 2009
Thread 1 advanced to log sequence 1127
Current log# 2 seq# 1127 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo2
Mon Aug 17 21:32:42 2009
Starting background process CJQ0
Mon Aug 17 21:32:42 2009
CJQ0 started with pid=135, OS id=22410
Mon Aug 17 22:00:00 2009
Setting Resource Manager plan SCHEDULER[0x2C09]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Mon Aug 17 22:00:02 2009
星期一 8月 17 22:00:02 2009
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownSCN) is 154290331
Mon Aug 17 22:00:02 2009
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Mon Aug 17 22:00:19 2009
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Mon Aug 17 23:47:30 2009
Thread 1 advanced to log sequence 1128
Current log# 3 seq# 1128 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo3
Tue Aug 18 01:32:02 2009
Thread 1 advanced to log sequence 1129
Current log# 1 seq# 1129 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo1
Tue Aug 18 02:00:00 2009
Clearing Resource Manager plan via parameter
Tue Aug 18 03:14:00 2009
Stopping background process CJQ0
Tue Aug 18 07:48:51 2009
Thread 1 advanced to log sequence 1130
Current log# 2 seq# 1130 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo2
Starting background process CJQ0
Mon Aug 17 20:02:23 2009
CJQ0 started with pid=172, OS id=12844
Mon Aug 17 20:18:09 2009
Stopping background process CJQ0 这个很正常呀,没看出异样,启动process,运行,结束...用一下语句可以查看process的相关信息
select * from v$session where paddr = (select addr from v$process where pid=172)不知道楼主的:自动停止运行 是什么意思?
看一下这段日志:
Tue Aug 18 02:00:00 2009
Clearing Resource Manager plan via parameter
Tue Aug 18 03:14:00 2009
Stopping background process CJQ0
Tue Aug 18 07:48:51 2009
Thread 1 advanced to log sequence 1130
Current log# 2 seq# 1130 mem# 0: /dev/sfdsk/pisadbvg/rdsk/lv_redo2 其中在18日凌晨3点14分钟以后,JOB作业就没有再执行了,之前都是正常执行的