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 NOVEMBER 04, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
- 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
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