| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Is Oracle Reliable ???ORA-07445
I have a query like this:
select fieldA, fieldB, fieldC
from TableA
where FieldD='1'
and FieldE in
(Select FieldE from TableB
where lower(FieldF)=lower('a constant string'))
order by fieldA;
FieldE of Table A is a foreign key to TableB.FieldsE.
Sometime it runs normal, however sometime it returned the error below and caused a core dump. The result from TkProf says that the execute plan is like this: full table scan of TableB, full table scan of TableA, and hash join. Any idea on this matter will be highly appreciated.
ORA-07445: exception encountered: core dump [qerhjSyncPendingIO]
[SIGSEGV] [Addr
ess not mapped to object] [16] [] []
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Sep 08 2000 - 17:04:08 CDT
 |
 |