Dynamic Query Generated by COGNOS is Spending Longer Parse Times In 12.2 as Compared to 11.2
(Doc ID 2453491.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- Parse time is higher in 12.2 in BI application with a lot of complex queries using literal values
- 10053 trace shows time spent on CBOT
TIMER: costing general plans cpu: 1.027 sec elapsed: 1.119 sec
TIMER: costing general plans cpu: 1.030 sec elapsed: 1.034 sec
TIMER: CBQT OR expansion SEL$71993FC3 cpu: 120.438 sec elapsed: 123.164 sec >>>>>>>> Considerable Time Spent here.
TIMER: costing general plans cpu: 1.479 sec elapsed: 1.497 sec
TIMER: costing general plans cpu: 1.316 sec elapsed: 1.317 sec
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 |
Cause |
Solution |