MarkView Advisor - Performance issues with Oracle 11g Database
Summary
Applies To
- ERP System: Oracle, SAP
- MarkView Advisor Version: MarkView 9.0 and Below
Behavior
Recently we have had reports from some customers experiencing performance issues related to MarkView Advisor with the Oracle 11g database. The performance slowdown occurs when there are a large number of invoice records being changed at the same time. Typical scenarios where this could occur would include processing month end jobs (e.g. Unaccounted Transactions Report) or importing a large amount of expense reports. These same performance issues do not occur with the Oracle 10g database.
Resolution
Product Development Engineering and Oracle Support has identified that installing Oracle Database Patch 10082277 will help Advisor performance in some customer environments. Additionally, MarkView 7.0.2 and 7.1.1 include a major architecture change to the Advisor product which further improves the performance when a large number of invoice records are modified at the same time.
If you are experiencing these performance issues due to MarkView Advisor you will want to ensure that Oracle Database Patch 10082277 is applied and that you are running MarkView 7.0.2/7.1.1 or higher.
Keywords: perform