Querys to monitor RAC
following few Query's will help to find out culprits- Query to check long running transaction from last 8 hours Col Sid Fo...
-
How to kill blocking session on object ? STEP1: Initially we need to find out blocking session on object SELECT o.owner, o...
-
Hey Guys, Tested handlecollisions parameter in replicat and performed DML on source database Results as follows --- scenari...
-
If the replicat or pump is abended on the trail with seqno and RBA with error message " ERROR OGG-01028 Incompatible recor...