Found tracefile omr_lgwr_841.tr, and below error after patched database to 10.2.0.4
/u00/app/oracle/admin/omr/bdump/omr_lgwr_841.trc
Oracle Database 10g Release 10.2.0.4.0 - Production
ORACLE_HOME = /u00/app/oracle/product/10.2.0
System name: SunOS
Node name: etravel2k
Release: 5.10
Version: Generic_147441-01
Machine: i86pc
Instance name: omr
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 841, image: oracle@etravel2k (LGWR)
*** 2012-11-23 09:52:50.704
*** SERVICE NAME:() 2012-11-23 09:52:50.703
*** SESSION ID:(275.1) 2012-11-23 09:52:50.703
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150676 bytes
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x10)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x10)
*** 2012-11-23 09:52:58.396
Warning: log write time 500ms, size 682KB
*** 2012-11-23 09:52:58.993
Warning: log write time 590ms, size 887KB
*** 2012-11-23 09:52:59.655
Warning: log write time 670ms, size 952KB
*** 2012-11-23 09:53:00.285
Warning: log write time 620ms, size 1087KB
*** 2012-11-23 09:53:00.918
Warning: log write time 640ms, size 960KB
*** 2012-11-23 09:53:01.594
Warning: log write time 670ms, size 1087KB
*** 2012-11-23 09:53:02.196
Warning: log write time 610ms, size 960KB
*** 2012-11-23 09:53:02.908
Warning: log write time 710ms, size 992KB
*** 2012-11-23 09:53:03.562
Warning: log write time 650ms, size 1055KB
/u00/app/oracle/admin/omr/bdump/omr_lgwr_841.trc
Oracle Database 10g Release 10.2.0.4.0 - Production
ORACLE_HOME = /u00/app/oracle/product/10.2.0
System name: SunOS
Node name: etravel2k
Release: 5.10
Version: Generic_147441-01
Machine: i86pc
Instance name: omr
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 841, image: oracle@etravel2k (LGWR)
*** 2012-11-23 09:52:50.704
*** SERVICE NAME:() 2012-11-23 09:52:50.703
*** SESSION ID:(275.1) 2012-11-23 09:52:50.703
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150676 bytes
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x10)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x10)
*** 2012-11-23 09:52:58.396
Warning: log write time 500ms, size 682KB
*** 2012-11-23 09:52:58.993
Warning: log write time 590ms, size 887KB
*** 2012-11-23 09:52:59.655
Warning: log write time 670ms, size 952KB
*** 2012-11-23 09:53:00.285
Warning: log write time 620ms, size 1087KB
*** 2012-11-23 09:53:00.918
Warning: log write time 640ms, size 960KB
*** 2012-11-23 09:53:01.594
Warning: log write time 670ms, size 1087KB
*** 2012-11-23 09:53:02.196
Warning: log write time 610ms, size 960KB
*** 2012-11-23 09:53:02.908
Warning: log write time 710ms, size 992KB
*** 2012-11-23 09:53:03.562
Warning: log write time 650ms, size 1055KB
when found out this error on metalink(601316.1), they tell this problem can occur on any platform, after upgrading to 10.2.0.4
And This warning message will be generated only if the log write time is more than 500 ms.
Anyway this problem tell us and we should check the disk is slow or not... and OS problem.
If everything OK... So, we can ignore these messages.
And This warning message will be generated only if the log write time is more than 500 ms.
Anyway this problem tell us and we should check the disk is slow or not... and OS problem.
If everything OK... So, we can ignore these messages.
Of course it depends (doesn't it always?). I'd say you don't want to see these warning about every second. Because the warning basically says that someone who tried to commit had to wait half a second or more - every second or more.
ReplyDeleteUsually it's a storage performance issue. Either the storage has to get faster, or the application has to commit less.