Inserts Slow For 5m Rows Or More Into GTT After Installing Patch 33150645
(Doc ID 2898432.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.13.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
After applying patch 33150645 the inserts into GTT 5M rows or higher is still slow.
Test case results:
12.2.0.1 Old version:
1M - 00:38, 2M - 00:59, 3M - 01:42, 4M - 02:46, 5M - 05:54, 6M - 04:51
19.13 W/O Patches:
1M - 01:19, 2M - 04:46, 3M - 11:11, 4M - 27:58, 5M - 42:57, 6M - 59:27
19.13 w/Bug fix 33150645
1M - 00:51, 2M - 02:15, 3M - 04:36, 4M - 07:56, 5M - 10:31, 6M - 36:17
12.2.0.1 Old version:
1M - 00:38, 2M - 00:59, 3M - 01:42, 4M - 02:46, 5M - 05:54, 6M - 04:51
19.13 W/O Patches:
1M - 01:19, 2M - 04:46, 3M - 11:11, 4M - 27:58, 5M - 42:57, 6M - 59:27
19.13 w/Bug fix 33150645
1M - 00:51, 2M - 02:15, 3M - 04:36, 4M - 07:56, 5M - 10:31, 6M - 36:17
Changes
Installed patch 33150645
Cause
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 |
| Changes |
| Cause |
| Solution |
| References |