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

Or get rid of 8.1.6 entirely. It is no longer supported by Oracle.

In addition to having a supported version of the database ... 8.1.7 is far more robust.

Daniel A. Morgan

Ushkalo Igor wrote:

> 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
Received on Sun Dec 23 2001 - 18:41:45 CST