We're doing some bench marking on a database upgraded from ASA10 to ASA16, and one composite report written in Power Builder that takes a little while to run in 10 (sometimes 20 minutes or so) is taking several hours in 16. The main connection spawns 8 child connections with the name "INT: Exchange", and it just hangs for hours (it does eventually finish).
It seems this is the database trying to run the multiple sub reports in parallel. But the performance is worse. I don't know if ASA10 was also running in parallel, but I don't see the INT: Exchange connections when running the report in 10.
Has anyone had a similar issue, and if so are there possible work arounds?
asked 01 Jul '16, 10:35
Short answer: SET OPTION PUBLIC.MAX_QUERY_TASKS = '1';
Medium answer: Read The New MaxBPs=768: Set MAX_QUERY_TASKS = '1'.
Long answer: Run Foxhound to see what is really happening...
( There's an even longer answer, but it might start a flame war with Engineering :)