Problem With Query Execution Time - No_merge Hints. Slow Parse of Complex Statement in 12.2
(Doc ID 2489090.1)
Last updated on DECEMBER 28, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
a. Create source table
b. Create target table
c. Insert with example row to source table
a. Create table as select
a. Insert as select
When we run SQL_1.sql then the parsing time (hard_parse) is about 10 sec.
When we run SQL_2.sql then the parsing time (hard_parse) is about 10 min.
The queries are created by the code generator - hence the large size.
Since the SQL parsing time is about 10 seconds, why insert as select takes 10 minutes. Is not it a bug?
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