Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Workload seemes not be balanced acoss 2 nodes

user60022Aug 11 2011 — edited Aug 16 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2011
Added on Aug 11 2011
5 comments
258 views