로그분석부탁드립니다. 자주 락에 걸립니다. 이와 상관이 있을까요
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