Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2880525
  • 博文数量: 599
  • 博客积分: 16398
  • 博客等级: 上将
  • 技术积分: 6875
  • 用 户 组: 普通用户
  • 注册时间: 2009-11-30 12:04
个人简介

WINDOWS下的程序员出身,偶尔也写一些linux平台下小程序, 后转行数据库行业,专注于ORACLE和DB2的运维和优化。 同时也是ios移动开发者。欢迎志同道合的朋友一起研究技术。 数据库技术交流群:58308065,23618606

文章分类

全部博文(599)

文章存档

2014年(12)

2013年(56)

2012年(199)

2011年(105)

2010年(128)

2009年(99)

分类: Oracle

2011-05-12 21:17:49

在10G中如果LGWR写出的时间超过500ms,LGWR的后台跟踪文件中将会记录一条警告信息。

如下所示:

[oracle@dbserver bdump]$ more dbserver_lgwr_13596.trc
/u01/admin/dbserver/bdump/dbserver_lgwr_13596.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/oracle
System name:    Linux
Node name:      dbserver
Release:        2.6.9-51.ELsmp
Version:        #1 SMP Tue Mar 20 23:10:05 EDT 2007
Machine:        i686
Instance name: dbserver
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 13596, image:
(LGWR)

*** SERVICE NAME:() 2011-05-06 21:27:43.086
*** SESSION ID:(1016.1) 2011-05-06 21:27:43.086
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150672 bytes
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x10)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x10)
*** 2011-05-07 10:51:54.297
Warning: log write time 1010ms, size 1250KB
*** 2011-05-07 10:52:13.475
Warning: log write time 1060ms, size 1038KB
*** 2011-05-07 10:52:35.184
Warning: log write time 900ms, size 1024KB
*** 2011-05-07 10:53:15.978
Warning: log write time 1520ms, size 1029KB
*** 2011-05-07 10:55:40.894
Warning: log write time 1120ms, size 1028KB
*** 2011-05-07 10:56:03.352
Warning: log write time 1410ms, size 1027KB
*** 2011-05-07 10:56:21.855
Warning: log write time 1240ms, size 1030KB
*** 2011-05-07 10:56:40.694
Warning: log write time 640ms, size 1024KB
*** 2011-05-07 10:57:01.076
Warning: log write time 1230ms, size 1024KB
*** 2011-05-07 10:57:21.276
Warning: log write time 830ms, size 1030KB
*** 2011-05-07 10:59:08.513


具体可以参考:

而在11G中ORACLE,跟踪文件中还附带了解决方法,如下所示:


[oracle@yikaiapp trace]$ more metisdb_lgwr_13085.trc
Trace file /u01/app/oracle/diag/rdbms/metisdb/metisdb/trace/metisdb_lgwr_13085.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/db11gr2
System name:    Linux
Node name:      yikaiapp
Release:        2.6.18-194.26.1.el5
Version:        #1 SMP Tue Nov 9 12:54:20 EST 2010
Machine:        x86_64
Instance name: metisdb
Redo thread mounted by this instance: 1
Oracle process number: 11
Unix process pid: 13085, image:
(LGWR)

*** 2011-05-08 10:05:47.726
*** SESSION ID:(855.1) 2011-05-08 10:05:47.726
*** CLIENT ID:() 2011-05-08 10:05:47.726
*** SERVICE NAME:(SYS$BACKGROUND) 2011-05-08 10:05:47.726
*** MODULE NAME:() 2011-05-08 10:05:47.726
*** ACTION NAME:() 2011-05-08 10:05:47.726
 
Warning: log write elapsed time 1396ms, size 4KB
 (set event 10468 level 4 to disable this warning)
*** 2011-05-08 18:05:58.111
Warning: log write elapsed time 1682ms, size 10KB
 (set event 10468 level 4 to disable this warning)
*** 2011-05-08 21:05:56.083
Warning: log write elapsed time 2574ms, size 11KB
 (set event 10468 level 4 to disable this warning)
*** 2011-05-08 22:24:35.700
Warning: log write elapsed time 1640ms, size 1KB
 (set event 10468 level 4 to disable this warning)
*** 2011-05-09 08:44:05.553
*** 2011-05-09 08:44:05.719
Warning: log write elapsed time 2394ms, size 0KB
 (set event 10468 level 4 to disable this warning)


SQL> alter system set event= '10468 trace name context level 4' scope=spfile;

System altered.


 

阅读(4544) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~