Re: ORA-03113 end of file on communication channel

From: david wendelken <davewendelken_at_earthlink.net>
Date: Tue, 30 Mar 2004 08:08:52 -0800 (PST)
Message-ID: <4091876.1080662932296.JavaMail.root@huey.psp.pas.earthlink.net>

I had the same problem with that configuration some years ago.

The same code on the same data would sometimes work, and sometimes not work.

As far as I could tell, ora-03113 was a catch-all code that other problems "fell into", and that the problem seemed to be a memory-resource problem.

I altered the program to partition its work, so that it did separate runs on subsets of the data rather than one run on the entire database.

That, and rebooting the windows machine at least once a week "just because" took care of the problem.

Good luck, I got a lot of practice in cursing on this one!

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:06:33 CST