IBM Sterling Ideas

formerly Watson Supply Chain

Submit new product ideas for IBM Sterling 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

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 More Information
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
  • Admin
    Ryan Wood commented
    13 Jan 19:25

    Thank you for participating in the request for enhancement community. Your feedback is valued. We have analyzed this request and would like to ask for more information.

    Could we get more details of the analysis that is being referred in the idea?
    Can you share info on what the bottleneck is that they are referring to?

    What all did try already?