Large query causes Oracle to hang
654320Aug 8 2008 — edited Aug 11 2008I have a 425K query I'm trying to execute over a JDBC connection. When I execute it, the Oracle server hangs and I have to restart it. The query works just fine in PostgreSQL and returns about 5600 rows.
I get the same hang if I try to execute the query in SQLplus.
I'm using Oracle 10g Express Edition.
Is there any way to execute such a large query in Oracle?
To answer the question that everybody is going to ask: No, I can't rewrite the query. It's automatically generated by a Java program.