Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Does using temporary tables degrade performance?

Thomas MorganMar 1 2016 — edited Mar 6 2016

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 3 2016
Added on Mar 1 2016
9 comments
14,967 views