Global temporary table (GTT) usage increased elapsed time after Jan RU 2021 (Doc ID 2798017.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.11.0.0.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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.