After having applied
10.2.0.3 Patch5 for Microsoft Windows
x64 (5946188) smon crashes intermittently during startup with ORA-600/ORA-7445 [kcbzfb_1].
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kcbzfb+346] [PC:0x4E8616] [ADDR:0xE8] [UNABLE_TO_READ] []
Current SQL statement for this session:
select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where
obj#=:1 and part=:2 and version=:3 order by piece#
Our server is an 8 way AMD Opteron processor box with 32Gb RAM.
Looking up the call stack trace in Metalink points to bug 6087497.
I have a SR open with Oracle, and this email is just to give you a warning in case you wanna do the same. Once I have the solution for this I'll post it.
Regards,
Andre