My Oracle Support Banner

PBCS:What is the Impact of 15 Min Query Governance Policy on BSO and ASO Cubes? (Doc ID 2587244.1)

Last updated on SEPTEMBER 23, 2019

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 19.08.56 and later
Information in this document applies to any platform.

Goal

According to PBCS August update(attached), a governor will be add.
This is mentioned in the 'upcoming changes' section which is scheduled to go into effect in the September patch release.

What's the impact of this change?
 

Quote:
-----------------------
UPCOMING CHANGES
QUERY GOVERNOR ON BSO AND ASO CUBES
Currently, there is no query governor on Essbase block storage and aggregate storage cubes.
Absence of a query governor can lead to excessive load created unintentionally by running ad hoc queries that take a very long time to complete.
In the September EPM Cloud update (Release 19.09), Oracle will add a query governor that limits all queries to a maximum 15 minutes execution time.
After Release 19.09 is applied to your environments (September 6, 2019 for test and September 20, 2019 for production environments),
the query governor will terminate queries that exceed the 15 minutes execution limit.
If you have any questions or concerns about the value of the governor (15 minutes), please open a Service Request.

Solution

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
Goal
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.