My Oracle Support Banner

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.


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.


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

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