10gR2 will automatically correct the errors.
I'm waiting for the version that will know that I *meant* to type
"select" when I actually type "seelct"
- Daniel Fink <daniel.fink_at_sun.com> wrote:
> 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
> >> 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
>
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Received on Mon Jul 21 2003 - 20:06:30 CDT