Re: Debug ORA-03113 on Oracle XE

From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com>
Date: Tue, 23 Jun 2009 10:14:45 +0200
Message-ID: <h1q30u$kb0$1_at_news.eternal-september.org>



Álvaro G. Vicario escribió:
> I have a web application written in PHP that's failing on one computer
> (and only that computer): a laptop that runs the Oracle 10g Express
> Edition. It fails when it executes a specific SELECT query: I get a
> "ORA-03113 end-of-file on communication channel" error and the
> connection drops.

For the records: it became clear that I was possibly hitting a resource limit of the Express Edition so I finally split my query in several pieces (with the help of one more temporary table) and now its working again.

Thank you all for your tips and hints. I've learnt a lot with this issue :)

-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--
Received on Tue Jun 23 2009 - 03:14:45 CDT

Original text of this message