Last week i got the following error on a 10gR2 Database when using Views:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [__VInfreq__kxccres+1516] [PC:0x2FB0BE4] [ADDR:0xC] [UNABLE_TO_READ] []
alter system set _optimizer_join_elimination_enabled=false scope=both;
I ran into the bug Oracle Bug 5579055, the solution for this is documented in note 370701.1
It is solved when you turn a optimizer feature off with:
alter system set _optimizer_join_elimination_enabled=false scope=both;