alter.log 로그분석부탁드립니다. 0 1 3,610

by l2monkeys [2008.08.08 22:20:48]


로그분석부탁드립니다. 자주 락에 걸립니다. 이와 상관이 있을까요

There are 3262 memory allocation errors for object-level stat
 in the last 15 minutes
Wed Aug  6 18:31:04 2008
Thread 1 advanced to log sequence 487192
  Current log# 5 seq# 487192 mem# 0: /ora_sms/data03/redo05.log
Wed Aug  6 18:31:04 2008
ARC1: Evaluating archive   log 4 thread 1 sequence 487191
ARC1: Beginning to archive log 4 thread 1 sequence 487191
Creating archive destination LOG_ARCHIVE_DEST_1: '/mgmt/arch/sms/0000487191.ARC'
ARC1: Completed archiving  log 4 thread 1 sequence 487191
 There are 3240 memory allocation errors for object-level stat
 in the last 15 minutes
 There are 1481 memory allocation errors for object-level stat
 in the last 15 minutes
Thu Aug  7 11:12:11 2008
alter tablespace SYSTEM begin backup
Thu Aug  7 11:12:11 2008
Completed: alter tablespace SYSTEM begin backup

 

Thu Aug  7 15:56:04 2008
Thread 1 advanced to log sequence 487216
  Current log# 5 seq# 487216 mem# 0: /ora_sms/data03/redo05.log
Thu Aug  7 15:56:04 2008
ARC1: Evaluating archive   log 4 thread 1 sequence 487215
ARC1: Beginning to archive log 4 thread 1 sequence 487215
Creating archive destination LOG_ARCHIVE_DEST_1: '/mgmt/arch/sms/0000487215.ARC'
ARC1: Completed archiving  log 4 thread 1 sequence 487215
 There are 3463 memory allocation errors for object-level stat
 in the last 15 minutes
 There are 493 memory allocation errors for object-level stat
 in the last 15 minutes
 There are 28 memory allocation errors for object-level stat
 in the last 15 minutes
Fri Aug  8 14:50:13 2008
alter tablespace SYSTEM begin backup
Fri Aug  8 14:50:14 2008
Completed: alter tablespace SYSTEM begin backup
Fri Aug  8 14:50:14 2008
alter tablespace UNDOTBS1 begin backup
Completed: alter tablespace UNDOTBS1 begin backup
Fri Aug  8 14:50:14 2008

 


ORA-00603: ORACLE server session terminated by fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4224 bytes of shared memory ("shared pool","select name,online$,contents...","sga heap(1,0)","library cache")
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4224 bytes of shared memory ("shared pool","SUPEROBJ$","sga heap(1,0)","library cache")
Thu Aug  7 11:12:29 2008
Errors in file /oracle/app/oracle/admin/SMSDB/bdump/smsdb_cjq0_3098.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4224 bytes of shared memory ("shared pool","select pos#,intcol#,col#,spa...","sga heap(1,0)","library cache")
Thu Aug  7 11:12:29 2008
Errors in file /oracle/app/oracle/admin/SMSDB/bdump/smsdb_cjq0_3098.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4224 bytes of shared memory ("shared pool","JOB$","sga heap(1,0)","library cache")
 There are 5109 memory allocation errors for object-level stat
 in the last 15 minutes
Thu Aug  7 11:13:45 2008
Thread 1 advanced to log sequence 487194
  Current log# 4 seq# 487194 mem# 0: /ora_sms/data03/redo04.log
Thu Aug  7 11:13:45 2008
ARC1: Evaluating archive   log 3 thread 1 sequence 487193
ARC1: Beginning to archive log 3 thread 1 sequence 487193
Creating archive destination LOG_ARCHIVE_DEST_1: '/mgmt/arch/sms/0000487193.ARC'
ARC1: Completed archiving  log 3 thread 1 sequence 487193
 There are 3588 memory allocation errors for object-level stat
 in the last 15 minutes
Thu Aug  7 11:37:52 2008

by 장태길 [2008.08.08 22:38:04]
ora-4031 에 대해서 검색 하시면 나올꺼에요 이 게시판에서두..
There are 1481 memory allocation errors for object-level stat
==> 이 부부은 9i 버그 인데 10G 에 수정 되었다고 하네요
버그 번호 2793038
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입