I recently dealt with an issue where a query would not complete when it was using a global temporary table. Once I replaced the temporary with a permanent table, it worked and returned in a few seconds.
Has anybody experienced this behavior?
If yes, what causes it and can something be done about it? Also, is there any documentation I can read to learn about this?
I checked and there was plenty of temp space.
This happens in an Oracle Exadata 11g environment.
Thanks,
Thomas