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

Brian Tkatch wrote:

> 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

ABC_at_DEVELOP on HERURG/ORC>SELECT /*+ ORDERED LEADING(Dual) */ * FROM Dual;

D
-
X

ABC_at_DEVELOP on HERURG/ORC>@who

USERNAME DBNAME SERVER VERSION ARCH SYSDATE

------------ --------- ------------ ----------------- ------- ----------------
ABC          DEVELOP   HERURG       8.1.6.3.0         STOPPED 24.12.2001 10:20

ABC_at_DEVELOP on HERURG/ORC>

So it seems you're hit in fixed bug... apply patchset 8.1.6.3

• Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru, ICQ #19972198