Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 290 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 115 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BIP SQL low performance
Lucy.liu
Rank 1 - Community Starter
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:
0