剛幫妳查了壹下,這個應該是壹個BUG,嘗試下下面的WORKAROUND
Abstract: ORA-7445 [ACCESS_VIOLATION] [_KKQSFOUNDINSOL+55]
*** 07/23/08 11:43 am ***
TAR:
----
PROBLEM:
--------
Select * from a view fails with the following error:
ORA-7445: exception encountered: core dump [ACCESS_VIOLATION]
[_kkqsFoundInSol+
55] [PC:0x203CC1F] [ADDR:0x8400038] [UNABLE_TO_READ] []
Current SQL statement for this session:
select * from test1a
DIAGNOSTIC ANALYSIS:
--------------------
The customer is trying to create a rewrite_equivalence using this view and is
unable to do so due to the error.
The issue was originally reported as
ORA-600: internal error code, arguments: [kkqscsoe:p1=p2], [], [], [], [],
[],
but this error was fixed by applying Patch 7154241
and now the ora-7445 is being reported.
Determined that setting optimizer_features_enable = '9.2.0' allows the select
from the view to complete without error.
WORKAROUND:
-----------
Setting optimizer_features_enable = '9.2.0' allows the select to work without
error. The work around is unacceptable since it is likely to
introduce new severe issues in the customers applications.