To investigate a query performance issues on one of our RAC database with two instances, I have initiated the 'oradebug dump errorstack 3' command for the session which was running the query. However, after few minutes I had canceled the operation as it was taking a long time and surprisingly, I found that the session is waiting for 'KJC: Wait for msg sends to complete' event. Although the event disappeared after few minutes, but it gave me an enough nightmare by that time. I didn't find any useful info about this event, but, I have to take sometime to investigate the behavior.
happy reading,
Jaffar
No comments:
Post a Comment