Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 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
Odi performance issues in using IKM BIAPPS SQL Target Override
user5533274
Rank 2 - Community Beginner
Hi,
I am just using a simple update statement in a interface with IKM IKM BIAPPS SQL Target Override. The update statement runs for a long time when it runs through ODI about 15 - 30 mins . But when run in SQL developer it runs under a second.
What could be the reasons?
regards
Arun D
0
Answers
-
Please check the operator log and confirm if its the "Perform Update" step itself which is taking 15-30 mins. I ask this because there is a possibility of other table maintenance tasks which could be dropping / re-building indexes and could be adding to task's overall execution time.
0 -
Yes just the update task takes a lot of time
0