Re: /*+ ORDERED LEADING() */ Destroys session.

I think this is a known bug - I vaguely
recall seeing it on Metalink a few
months ago; possibly on one of those
'bugs fixed by patch x.x.x.x' lists.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Brian Tkatch wrote in message <3c25fd79.2942722203_at_news.alt.net>...


>Yeah, yeah, I know, using these two contradictory hints is stupid.

>None-the-less, read on.

>

>OS: RedHat Linux (Kernel 2.2.12-20)

>DB Version: 8.1.6

>

>Oracle8i Designing and Tuning for Performance

>Release 2 (8.1.6)

>Chapter 7, "Using Optimizer Hints"

>Section: Using Hints

>Sub-Section: Hints for Join Operations

>Paragraph Title: LEADING

>Text: If you specify the ORDERED hint, then it overrides all LEADING

>hints.

>

>So, I dutifully tried this out in a number of ways. Here's an easy way

>of seeing the problem:

>

><<

>SELECT /*+ ORDERED LEADING(Dual) */ * FROM Dual;

><<

>

>SQL*PLUS responded with:

>

><<

>SELECT /*+ ORDERED LEADING(Dual) */ * FROM Dual

>*

>ERROR at line 1:

>ORA-03113: end-of-file on communication channel

><<

>