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.
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