Re: ORA-03113 end of file on communication channel

  • From: david wendelken <davewendelken@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 30 Mar 2004 08:08:52 -0800 (PST)

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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: