Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-03113 end of file on communication channel

RE: ORA-03113 end of file on communication channel

From: <Surendra.Tirumala_at_ky.gov>
Date: Tue, 30 Mar 2004 11:26:20 -0500
Message-ID: <063F65E6A14D0C47A5E9954B3C323544042F28EC@agency31.state.ky.us>


We had the same error once (OS was Solaris and FE was Centura)), it generated trace files(udump) though. And the culprit was a recursive join.

Ex: We had the select as ...

"select list from a1,a2,a3
where <...conditions..>
and

a1.col1=b1.col1
b1.col1=c1.col1
c1.col1=b1.col1;"

And eliminating "c1.col1=b1.col1" fixed the problem.

Surendra Tirumala
Database Administrator
Cabinet for Education
Commonwealth of Kentucky
Ph: (502) 564-9375x380
Surendra.Tirumala_at_ky.gov

-----Original Message-----

From: Craig Healey [mailto:c.healey_at_hhsuk.com] Sent: Tuesday, March 30, 2004 9:41 AM
To: oracle-l_at_freelists.org
Subject: ORA-03113 end of file on communication channel

Any help would be appreciated.
Oracle 8.1.7 on Windows 2000 Server.

We have a complex process here, written in VB. It takes about 4 hours to run. Last week it crashed with ORA-03113 showing on the user's screen, but no trace or log files. It's crashed twice today, again with no files generated. This is a major process and I'm under pressure to come up with a solution. I've googled, and checked Metalink, but the error is so general that without an error file I don't know where to start, other than blindly applying "solutions" and hoping one works. I tried tracing the session, but I ended up with 5Mb of FETCH/EXEC in a cursor loop within seconds. There is a lot of VB code, cursors and temporary tables used, and it's politically difficult to re-write. Anyone have any idea where I can start looking for the problem?

Craig Healey




DISCLAIMER
The information on this e-mail is confidential and may be legally privileged. It is intended
solely for the addressee and others authorised to receive it. If you are not the intended
recipient, any disclosure, copying, distribution or action taken in reliance on its contents
is prohibited and may be unlawful.

Any views or opinions expressed in this message are those of the individual sender.
No contract may be construed by this e-mail.

NOTIFICATION WITH REGARD TO PRIVACY
Every E-mail in and out of the HHS Domain passes through a moderator. Any email
Quarantined within that checker will be subject to scrutiny and may be investigated
further in the interest of protecting the everyday activities of this company.

Any queries regarding this message please notify system.administrator_at_hhsuk.com.

Swept by MIMESweeper for the presence of computer viruses (www.mimesweeper.com)





Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Mar 30 2004 - 10:24:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US