We have BMF 5.0 with 4 node RAC.
The schema is created with 12000 warehouses for a total size of little over 1TB.
We are seeing very little or poor scaling when going to 2 Node test.
There is extreme contention on C_WAREHOUSE, C_DISTRICT tables.
and on C_ORDER_I1 and C_ORDER_LINE_I1 indexes.
The two tables were fixed by setting PCTFREE=98.
With the indexes, we tried 4 hash partitions with negative effect.
Please let us know if BMF is sending different rows from different warehouses
to different nodes in the Cluster?
Currently, that seems to be the issue. AWR and ADDM reports arrive at the same conclusion.
Any help will be deeply appreciated.