Some Analyses do not Hit the Query Cache in OAC/OAS
(Doc ID 2773572.1)
Last updated on JUNE 01, 2023
Applies to:
Oracle Analytics Cloud - Version N/A to N/A [Release 14.1]Information in this document applies to any platform.
Symptoms
Cache is enabled in the OAC system (Console > System Settings > Performance and Compatibility > Cache Enabled).
Some reports are seeding the cache on the first execution but are not hitting the cache on subsequent executions.
This issue is only encountered by some (not all) reports, resulting in poor report performance.
It is observed that every time the reports are executed, the Logical SQL includes SET VARIABLE OBIS_REFRESH_CACHE=1 so the OBIS cache is never hit.
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 |
| References |