AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,
14 (SELECT VALUE
15 FROM v$parameter
16 WHERE NAME = 'user_dump_dest') d
17 /
TRACE_FILE_NAME
--------------------------------------------------------------------------------
/ora10g/app/admin/super/udump/super_ora_31179.trc
打开/ora10g/app/admin/super/udump/super_ora_31179.trc文件可以看到DBW9等一系列后台进程描述是以ksbdp 开始的，并进一步可以看到其内存地址，结构体描述名字
引用
...
ksbdp kcbdw9_ [200097F4, 20009820) = 00000036 00000000 00000000 00000000 ...
Dump of memory from 0x20009804 to 0x20009820
20009800 39574244 00000000 00000000 [DBW9........]
20009810 00000000 00000000 00000000 00010009 [................]
KSBDPPRO = 0X00000000
KSBDPSER = 0
KSBDPERR = 0
KSBDPNAM = 'DBW9'
KSBDPFLG = 0
ksbdp kcbdw10_ [20009820, 2000984C) = 00000037 00000000 00000000 00000000 ...
Dump of memory from 0x20009830 to 0x2000984C
20009830 61574244 00000000 00000000 00000000 [DBWa............]
20009840 00000000 00000000 0001000A [............]
KSBDPPRO = 0X00000000
KSBDPSER = 0
KSBDPERR = 0
KSBDPNAM = 'DBWa'
KSBDPFLG = 0
...
有了以上基本信息，即可深入研究了