RE: HP-UX 11i/9.2.0.3/Strange Executions

Color may be irrelevant, depending on amount.

"Gogala, Mladen" <MGogala_at_oxhp.com>
Sent by: ml-errors_at_fatcity.com
 07/22/2003 12:34 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: HP-UX 11i/9.2.0.3/Strange Executions

Hopefully, not a pink one?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com

-----Original Message-----
Sent: Tuesday, July 22, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L

10gR4 will modify payroll and send me the check.

Jared

On Monday 21 July 2003 19:39, Mladen Gogala wrote:
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.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