DBWR Process Generate Huge Trace Files dbw*.trc (Doc ID 2972080.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Symptoms

Large trace files are produced in the "Diag Trace" location. These files are large (3,673,693,176 bytes) typically and need to be deleted promptly to avoid space problems.

-rw-r-----. 1 oracle dba 3673693176 Aug 31 09:19 _dbw0_7172.trc
-rw-r-----. 1 oracle dba    8307852 Aug 31 09:19 _dbw0_7172.trm
-rw-r-----. 1 oracle dba 3807025976 Aug 31 09:19 _dbw1_7177.trc
-rw-r-----. 1 oracle dba    8469009 Aug 31 09:19 _dbw1_7177.trm
-rw-r-----. 1 oracle dba 3647986220 Aug 31 09:19 _dbw2_7182.trc
-rw-r-----. 1 oracle dba    8203008 Aug 31 09:19 _dbw2_7182.trm
-rw-r-----. 1 oracle dba 3770401261 Aug 31 09:19 _dbw3_7187.trc
-rw-r-----. 1 oracle dba    8440157 Aug 31 09:19 _dbw3_7187.trm

A typical trace file contains entries like these

kcfopn: skip resync fno 121 ver 3 pfv 3 pfob 0x6ac930760 pkv 0 gkv 0 pfob 0x6ac930760 gfob 0x6ac930760
kcfopn: skip resync fno 121 ver 3 pfv 3 pfob 0x6ac930760 pkv 0 gkv 0 pfob 0x6ac930760 gfob 0x6ac930760
kcfopn: skip resync fno 121 ver 3 pfv 3 pfob 0x6ac930760 pkv 0 gkv 0 pfob 0x6ac930760 gfob 0x6ac930760
kcbb_prepare: might be encrypting <9/2, 0x240fad8 (block 64216)>
BH (0xa17b83c40) file#: 121 rdba: 0x0240fad8 (9/64216) class: 38 ba: 0xa11774000
 set: 93 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,25
 dbwrid: 0 obj: -1 objn: 0 tsn: [9/2] afn: 121 hint: f
 hash: [0x97fb523d0,0x68b7798e8] lru: [0xc3fb6cf88,0xd0fcc6078]
 obj-flags: object_write_list
 ckptq: [0xdcfad1428,0x68bd78348] fileq: [0xa27b2e6d8,0x6abf21c38]
 objq: [0x6386706e0,0x6386706e0] objaq: [0xc3fb6cfc0,0xd0fcc60b0]
 st: XCURRENT md: NULL fpin: 'ktuwh03: ktugnb' fscn: 0x1fc16576b8e tch: 2
 flags: buffer_dirty being_written block_written_once
 LRBA: [0x4d030.126.0] LSCN: [0x1fc1657b3ed] HSCN: [0x1fc1657b3ed] HSUB: [5]
 Printing buffer operation history (latest change first): (cnt 10)
 01. sid:01 L913:bxsv:sw:objq        02. sid:01 L608:bxsv:bis:FBW
 03. sid:11 L464:chg1_mn:bic:FMS     04. sid:11 L778:chg1_mn:bis:FMS
 05. sid:11 L362:chg1:set:MEXCL      06. sid:11 L464:chg1_mn:bic:FMS
 07. sid:11 L614:chg1_mn:bis:FBD     08. sid:11 L922:klbc:sw:cq
 09. sid:11 L778:chg1_mn:bis:FMS     10. sid:11 L362:chg1:set:MEXCL
 11. sid:01 L192:kcbbic2:bic:FBD     12. sid:01 L191:kcbbic2:bic:FBW
 13. sid:01 L602:bic1_int:bis:FWC    14. sid:01 L822:bic1_int:ent:rtn
 15. sid:01 L832:oswmqbg1:clr:WRT    16. sid:01 L930:kubc:sw:mq
 buffer tsn: 2 rdba: 0x0240fad8 (9/64216)
 scn: 0x1fc1657b3ed seq: 0x02 flg: 0x04 tail: 0xb3ed0202
 frmt: 0x02 chkval: 0xf23b type: 0x02=KTU UNDO BLOCK
kcbb_prepare_2: not encrypting <[9/2], 0x240fad8 (block 64216)> scn 0x1fc1657b3ed FEN 0x0
kcfopn: skip resync fno 121 ver 3 pfv 3 pfob 0x6ac930760 pkv 0 gkv 0 pfob 0x6ac930760 gfob 0x6ac930760
kcfopn: skip resync fno 121 ver 3 pfv 3 pfob 0x6ac930760 pkv 0 gkv 0 pfob 0x6ac930760 gfob 0x6ac930760

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.