Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Analytics Publisher

BIP SQL low performance

Question

Views

Comments

Lucy.liu Rank 1 - Community Starter

May 15, 2023 3:01AM 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: