RE: Win2000/8.1.7.3.0/SQL

John - It is available at http://www.hotsos.com/catalog/

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, August 20, 2002 7:09 PM
To: Multiple recipients of list ORACLE-L

Mike,

Just one more thing to check before you close this: Can you run a 10053 trace? This is a 'CBO trace' and should provide some interesting reading. There was an excellent paper from Wolfgang Breitling on the 10053 at the recent IOUG and should be available somewhere...

Inquiring minds want to know!

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Disappointments are inevitable in Life, but discouragement is optional. You decide!

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Vergara, Michael (TEM) [mailto:mvergara_at_guidant.com]
> Sent: Tuesday, August 20, 2002 4:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Win2000/8.1.7.3.0/SQL
>
>
> John:
>
> That makes perfect sense in view of the fact that only the
> /*+ RULE */ hint makes the query run. I'm not gonna try and
> find the root cause any more; I've modified my queries and
> I get answers again.
>
> My Thanks to all who have helped me with this issue.
>
> Cheers,
> Mike
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).