Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

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: