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!

How to find blocking sessions on a 2 node RAC DB?

sweetritzJun 6 2014 — edited Jun 6 2014

Hi DBAs,

I know the query which will give me the blocking session on a standalone DB like below:

select l1.sid, ' IS BLOCKING ', l2.sid  from v$lock l1, v$lock l2

where l1.block =1 and l2.request > 0  and l1.id1=l2.id1 and l1.id2=l2.id2;

But now i have a small issue that my other DB is a 2 node RAC DB (2 instances which are on 2 different located severs). And there seems to be some memory issues and I need to find the sessions which are open since long time and i need to kill them. Can someone help me in finding the blocking session in RAC environment and also how to kill them in RAC environment.

DB environment:

version: Oracle 10.2.0.5

Production

2 node RAC

Regads,

Ritu

This post has been answered by Bhavi Savla on Jun 6 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2014
Added on Jun 6 2014
12 comments
10,333 views