Oracle Analytics Publisher

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

BIP SQL low performance

Question
21
Views
0
Comments
Rank 1 - Community Starter
edited Oct 11, 2023 6:39PM in Oracle Analytics Publisher

We have two instances with same transaction data.

And we released the same data model and report in the two instances.

Instance 1 has good performance(100s) but instance 2 is in low performance(500s).

I checked the execution plan of two instances.

Table name FND_BUG35276363_PSR1 is founded in instance 2's execution plan which is not involved in sql statement.

Execution plan of instance 1 don't have such a thing.

Is there any information about such a table name? Does it impact the performance of sql?


Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.