DB: 18.104.22.168, db size: 21 TB (allocated), used: 7 GB, 3 nodes cluster, almost more than 12 services are running, but they have placed only one service on one node means:
1. service_a is only running on node1
2. service_b is on node2
3. service_c is on node3
when I asked it was told that because most of the activity is INSERT only and if service will be running on multiple nodes, there will be a cache fusion wait or interconnect wait.
the configuration is something like this:
Preferred instances: orclprdi1
Available instances: orclprdi2,orclprdi3
My question, is this correct understanding that if there is one service doing mostly INSERTs, we should assign them to only one node, not 2 or all the 3, if we do so, then we might encounter INTERCONNECT waits or cache fusion waits.
I'm not that strong on RAC, that's why putting this question here ... please assist/guide/advise ... much appreciated and thanks in advance.
Also looking for some advise on this allocation & used space, there is huge difference and due to this backup is taking for ever, looking for some expert thoughts there too.