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
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
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|
|Link to original RFE|