Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!sjc1.usenetserver.com!news.usenetserver.com!cyclone.bc.net!canoe.uoregon.edu!mencken.net.nih.gov!not-for-mail
From: "hastenthunder" <hastenthunder@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Top-n-analysis causing ORA-03113
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Message-ID: <EMrRc.884$Ny6.1912@mencken.net.nih.gov>
Date: Sun, 8 Aug 2004 11:37:07 -0400
NNTP-Posting-Host: 199.249.158.90
X-Trace: mencken.net.nih.gov 1091979428 199.249.158.90 (Sun, 08 Aug 2004 11:37:08 EDT)
NNTP-Posting-Date: Sun, 08 Aug 2004 11:37:08 EDT
Xref: core-easynews comp.databases.oracle.server:227808
X-Received-Date: Sun, 08 Aug 2004 08:36:04 MST (news.easynews.com)

Hi Experts,

I'm getting a ORA-03113: end-of-file on communication channel exception on
Oracle 10g/Red Hat Adv. Sever 3 when executing the following query:

SELECT *
FROM (SELECT person0_.person_id AS person_id0_,
             facility2_.fac_id AS fac_id1_,
             person0_.display_id AS display_id0_,
             facility2_.under_contract AS under_co3_1_
      FROM person person0_ INNER JOIN
      fac_affl affiliatio1_ ON person0_.person_id = affiliatio1_.person_id,
      facility facility2_
      WHERE affiliatio1_.fac_id = facility2_.fac_id
      ORDER BY person0_.person_id
      )
WHERE rownum <= 10

I'm really puzzled, if this is not a bug, can anyone tell me why running a
query would cause an ORA-03113?

The query seem to work OK when I take the order-by clause out.

The sql looks ugly, I know, and please don't ask me why the query is written
like this.  Our developers uses hibernate to auto-generate these SQL
statements.


Thanks in advance for your help!