10gR3 will read programmer's mind and automatically correct all design
errors. RDBMS 11T will look like Arnie Schwartzenegger ("T" is for
"Terminator"). I'll be back.
On 2003.07.21 22:04, Rachel Carmichael wrote:
> 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
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Jul 21 2003 - 20:38:59 CDT
