Okay, so its Monday...
What I meant to say is that are the queries with different execution plans the ones
encountering 7445s. If there is a common thread in the execution plans (i.e. hash join
instead of nested loops), then the hj may be triggering the 7445s.
Actually, 10g will have a new "FORETELL PLAN" feature that will predict the execution
plan and all associated errors, complaints, incorrect data...
"Gogala, Mladen" wrote:
>
> Actually, I'm quite unaware of ORA-07745 as an execution plan. Can "EXPLAIN
> PLAN"
> foretell the error?
>
> Mladen Gogala
> Oracle DBA
> Phone:(203) 459-6855
> Email:[EMAIL PROTECTED]
>
> -----Original Message-----
> Sent: Monday, July 21, 2003 6:20 PM
> To: Multiple recipients of list ORACLE-L
>
> Michael,
> When you say 'different execution plans', what are the differences?
> Is the choice in execution plans causing the ORA-07445? If so, why are the
> execution plans different (there has to be a reason)? Statistics,
> parameters, etc. will alter the execution plan choices.
> The 7445 definitely deserves a call to Oracle Support (through SAP
> if need be). 7445s are a royal pain to diagnose (like 600s).
>
> Daniel
>
begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
