My Oracle Support Banner

Some Analyses do not Hit the Query Cache in OAC/OAS (Doc ID 2773572.1)

Last updated on MAY 10, 2021

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.