Workload seemes not be balanced acoss 2 nodes
Hi All,
My DB is 11.1.
We have a sevice named daily_batch and we have assgined 2 nodes(node1 and node2) to this sevice.
And in client tns,both load_balance and fail_over are set to on or yes.
The application has run for years with no obvious problems. But when reading awr reports for node1 and 2 within the same period, I have found that node2 always has less workload than node1.
Can someone tell me how to check awr report to verify that the workload has been balanced across these 2 nodes, please?
Best regards,
Leon
My DB is 11.1.
We have a sevice named daily_batch and we have assgined 2 nodes(node1 and node2) to this sevice.
And in client tns,both load_balance and fail_over are set to on or yes.
The application has run for years with no obvious problems. But when reading awr reports for node1 and 2 within the same period, I have found that node2 always has less workload than node1.
Can someone tell me how to check awr report to verify that the workload has been balanced across these 2 nodes, please?
Best regards,
Leon
0