Oracle Database Discussions

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!

How to determine hot blocks on interconnect

617544Jul 13 2009 — edited Mar 2 2010

Hi,

I want to identify which queries cause most interconnect activity on 2-node RAC cluster and which object-blocks are sent most through interconnect. If i can identify these, i can tune queries and maybe redistribute sessions in order to lower interconnect traffic. Can you suggest a way to do this?

By the way, i don't have a problem now. I just want to do some fine tuning and be prepared for a near future production deployment.

IBM AIX 5.3,
Oracle 10.2.0.4 2-node RAC

Regards,
erkan

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2010

Added on Jul 13 2009

#general-database-discussions

2 comments

2,136 views