Several Allocations Using Tree Filter are Performing Very Slow Even After Index and Table Tuning
(Doc ID 748793.1)
Last updated on JANUARY 07, 2010
Applies to:Oracle Profitability Manager - Version: 4.5 to 4.5.39
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version: 4.5
Oracle Performance Analyzer - Version: 4.5
Each allocation uses a different Org Unit Tree Filter ID.
Currently Ledger_Stat is partitioned with degree of parallelism = 4. OFSA_IDT_ROLLUP also has
degree of parallelism = 4. OFSA multi-processing is currently not being used.
Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Run single large batch of 208 Allocation IDs with this set of 18 allocations all using different Tree Filter Ids.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!