| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: HP-UX 11i/9.2.0.3/Strange Executions
This is a multi-part message in MIME format.
--------------9149114AE9EBFD8701D79B7D Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
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:mgogala_at_oxhp.com
>
> -----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
>
--------------9149114AE9EBFD8701D79B7D
Content-Type: text/x-vcard; charset=us-ascii;
name="daniel.fink.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Daniel Fink Content-Disposition: attachment;
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:daniel.fink_at_sun.com
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
Received on Mon Jul 21 2003 - 16:42:50 CDT
 |
 |