IBM Sterling Ideas

formerly Watson Supply Chain

Submit new product ideas for Watson Supply Chain solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed. Order Management, Store Engagement, Watson Order Optimizer, Inventory Visibility, CPQ and Call Center are now part of Watson Supply Chain

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

Submit ideas for other Watson Customer Engagement Products:

Watson Marketing
Watson Campaign Automation
Watson Commerce

Support for parallel query execution for oracle databases

I would like to highlight lack of parallel processing/query parallelism in SI database queries. We have SI database of huge size (>1TB). Our whole database is an industry grade RAC cluster with multiple cores. Yet one of the recurrent problems that we face is slow query execution at database level. 

 

After further analyzing, we found that it is not the database that is causing bottleneck, the application is not taking advantage of query level parallel processing offered by oracle.

 

Same application queries were executed in drastically low time with help of parallel hints. Unfortunately, when I looked in jdbc.properties file, I found that all the queries were obsolete referring to oracle 8i/9i. 

 

Can you please explain why SI/SFG is not leveraging query level parallelism offered by Oracle? Same issue is not also addressed in SI 6. If resolved, it would be drastically helpful to customers like us which have huge databases

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Oct 9 2019
  • Needs review
How will this idea be used?

This will help customers who have brought heavy DB clusters but the same are being underutilized

What is your industry? Banking
What is the idea priority? Urgent
DeveloperWorks ID
RTC ID
Link to original RFE
  • Attach files