dbms_xmlgen.getxml hangs
Platform: Linux RH5.1
Problem history and description:
When the database was still version 10.2.0.4, we had a problem with the job that executed the dbms_xmlgen.getxml command, where if the file it created was over 2GB, the output in the resulting file was truncated. We got around this problem by coding the job so that it split the results of the command into multiple files (by executing the command so that it selected a subset of the data each time). This solution worked without fail for years.
After we upgraded to 11.2.0.3, the same job/command hangs on the same commands (see below). I have let the command run for hours with nothing being returned. I have verified that the connection is not in a wait state and is not being blocked by other connections, it just never returns any data and never finishes. The select itself is very simple and when executed by itself returns the results in just few seconds. I am able to get the command to run by reducing the number of rows that are returned in the select statement, but for the table