My Oracle Support Banner

Add RRS Document Causing High CPU Utilization (Doc ID 2466510.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle Financial Services Regulatory Reporting - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.2 version, Web UI

ACTUAL BEHAVIOR
---------------
Add RRS document is causing high CPU utilization

Client tried to add the document in RSS , the query tries to pull all the document from the database without any filter clause which is causing the DB to slow , if multiple people try to add the doc at the same time. Below is the query and attaching the screenshot/log of the RSS doc tab for reference.




BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are experiencing slowness

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.