Re: Events, complete list?

I am mistaken. I did not find it before, but found it now. It is event 10176.

Oracle 8.1.6.0, Query over a database link, both databases share same box and Oracle_Home.

ORA-02070: database REFRESH does not support this date function in this context

Oracle Support Suggested:

This might be related to bug 164796/1046027

This problem was introduced in 8.1.5
  A Query which leadsto a remote colocated join   may return incorrect results if the query has non simple   join predicates on the remote tables.
  This only happens when using CBO.

  Workaround:
  Setting event 10176

  alter session set events '10176 trace name context forever';

  Customer is changing optimizer_mode = rule.

  The inserts are successful.

My list goes up to
----- Original Message -----
From: Steve Adams <steve.adams_at_ixora.com.au> To: Tom Pall <tpall_at_cdproc.com>
Sent: Thursday, August 03, 2000 5:33 PM
Subject: RE: Events, complete list?

> Hi Tom,
>
> Would you mind posting a description of the problem and the event number
> to the list?
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
>
> -----Original Message-----
> From: Tom Pall [mailto:tpall_at_cdproc.com]
> Sent: Friday, 4 August 2000 8:35
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Events, complete list?
>
>
> $ORACLE_HOME/rdbms/mesg/oraus.msg
>
> It is not a *complete* list, as Oracle Support gave me one to set to
> prevent a problem
> fixed in 8.1.6.2/8.1.7 which does not show up in the list.
>
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Thursday, August 03, 2000 2:41 PM
>
>
> > Does anyone know where I can find a complete list of settable events?
> >
> > Example,
> >
> > Set the 10046 event, trace level 12 to get the binds, waits etc.
> > exec sys.dbms_system.set_ev( sid, serial, 10046, 12, '' )
> > or in init.ora
> > event = " trace name context forever, level 4"
> >
> > Thanks,
> > Linda Hagedorn
> >
> >
> > --
> > Author: Linda Hagedorn
> > INET: Linda_at_pets.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
>
> --
> Author: Tom Pall
> INET: tpall_at_cdproc.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Thu Aug 03 2000 - 17:52:17 CDT