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

Last updated on MAY 25, 2022

Applies to:

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

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