Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Enhance the errors related to initialization blocks taking too long.

Needs Votes
51
Views
0
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Oracle Support

Description (Required):

In different cases, customers face the 504 error while logging to OAC, and after investigation, it turns out that some initialization blocks are being executed, and are taking too long to get response from database, specially when the Database is on premises.


We are looking for a way to trace these long running or failing queries and provide the customer with a meaningful error message, that can provide the name of the connection pool once it takes longer than a specific amount of time to execute.


Use Case and Business Need (Required):

This will help customers to self troubleshoot their performance issues, specially when the RPD is migrated from on-premises to the cloud.

Enhancement Request / Service Request:

1
1 votes

Needs Votes · Last Updated