Global temporary table (GTT) usage increased elapsed time after Jan RU 2021
(Doc ID 2798017.1)
Last updated on AUGUST 11, 2021
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
After applying the January 2021 Release Update (updating from July 2020) specific application processes ran into elapsed times that increased 100%.
This was reported by the first customer which applied this database RU and uses the application.
It appeared that specific commit statements took 9 to 10 times more than before during these processes.
Finding a possible database cause for this, it seems that the involvement of global temporary table usage causes this extreme delay.
Increase in elapsed time is related to a change after applying RU January 2021 and we could not reproduce the increase with October 2020).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document