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