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 <[EMAIL PROTECTED]> 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:[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 > __________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
