oracle 关于bdump文件夹下的trc文件 OS:windows server 2003DB:Oracle 9i ORACLE 数据库 实际数据量只有5G 安装目录下 E:\oracle\admin\FG8\bdump 这个文件夹下面 每天产生一个trc文件使得 ORACLE 安装文件 有 100多G了 增速十分惊人,请问各位前辈这是什么原因? 告急! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Dump file d:\oracle\admin\xhfg\bdump\xhfg_smon_6036.trcFri Oct 28 15:55:34 2011ORACLE V9.2.0.1.0 - Production vsnsta=0vsnsql=12 vsnxtr=3Windows 2000 Version 5.2 Service Pack 2, CPU type 586Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - ProductionWindows 2000 Version 5.2 Service Pack 2, CPU type 586Instance name: xhfgRedo thread mounted by this instance: 1Oracle process number: 6Windows thread id: 6036, image: ORACLE.EXE*** SESSION ID:(5.1) 2011-10-28 15:55:34.000*** 2011-10-28 15:55:34.000SMON: Restarting fast_start parallel rollback*** 2011-10-28 15:55:52.000SMON: Parallel transaction recovery slave got internal errorSMON: Downgrading transaction recovery to serial[1] Error during leaf key undo operation: 3 count=3KTB Redo op: 0x03 ver: 0x01 op: ZDump kdilk : itl=3, kdxlkflg=0x1 sdc=0 indexid=0x2c3b973 block=0x03023bd5purge leaf row(13): 05 36 36 39 36 38 06 03 07 67 86 00 00dump block being looked at nowBlock header dump: 0x03079087 Object id on Block? Y seg/obj: 0x8f5d csc: 0x00.99e56c7 itc: 3 flg: E typ: 2 - INDEX brn: 0 bdba: 0x307900a ver: 0x01 inc: 0 exflg: 0 Itl Xid Uba Flag Lck Scn/Fsc0x01 0x0009.00e.00012c1f 0x00823fb5.08f4.01 CB-- 0 scn 0x0000.05c47b5d0x02 0x0004.019.000278e8 0x0080085f.1014.33 --U- 1 fsc 0x0011.099e56ca0x03 0x000a.01e.0001d922 0x00800638.0d1b.27 --U- 2 fsc 0x0022.099e56e8这是最近TRC文件的前部分,不知道怎么分析,看不明白。 oracle审计 oracle 超简单触发器 Warning: Trigger created with compilation errors Oracle中检索数据的方法哪个更好? 谁帮帮我写个触发器好吗? Help! How to get the ratio of M to F 我写了一个存储过程,有一个参数,请问该如何调用? 求delphi如何与ORACLE建立数据库连接? 如何将SQLSERVER 中的表导入ORACLE 9I中 特急,imp导入问题,帮帮忙 数据库共享池 触发器错误 RMAN备份完为什么立即成了"废弃"??? 如何从oracle客户端以sysdba用户登陆
Fri Oct 28 15:55:34 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Instance name: xhfgRedo thread mounted by this instance: 1Oracle process number: 6Windows thread id: 6036, image: ORACLE.EXE
*** SESSION ID:(5.1) 2011-10-28 15:55:34.000
*** 2011-10-28 15:55:34.000
SMON: Restarting fast_start parallel rollback
*** 2011-10-28 15:55:52.000
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
[1] Error during leaf key undo operation: 3 count=3
KTB Redo
op: 0x03 ver: 0x01
op: Z
Dump kdilk : itl=3, kdxlkflg=0x1 sdc=0 indexid=0x2c3b973 block=0x03023bd5
purge leaf row
(13): 05 36 36 39 36 38 06 03 07 67 86 00 00
dump block being looked at now
Block header dump: 0x03079087
Object id on Block? Y
seg/obj: 0x8f5d csc: 0x00.99e56c7 itc: 3 flg: E typ: 2 - INDEX
brn: 0 bdba: 0x307900a ver: 0x01
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0009.00e.00012c1f 0x00823fb5.08f4.01 CB-- 0 scn 0x0000.05c47b5d
0x02 0x0004.019.000278e8 0x0080085f.1014.33 --U- 1 fsc 0x0011.099e56ca
0x03 0x000a.01e.0001d922 0x00800638.0d1b.27 --U- 2 fsc 0x0022.099e56e8这是最近TRC文件的前部分,不知道怎么分析,看不明白。