Hello All,
We have just migrated our 8i database to 11g r2. after migration , we are running utlrp.sql , but it's hanging for some reason. I also checked the wait events and show "HS message to agent". seems , this talks about hetrogenious services , but I am yet to find out, how to diagnose and troubleshoot this?
SQL> select sid , event , WAIT_TIME , SECONDS_IN_WAIT , STATE from v$session_wait where sid = 3526 order by 3 desc
2 /
SID EVENT WAIT_TIME SECONDS_IN_WAIT STATE
---------- --------------------------------------------- ---------- --------------- -------------------------------------------------
3526 HS message to agent -1 891 WAITED SHORT TIME
SQL> /
SID EVENT WAIT_TIME SECONDS_IN_WAIT STATE
---------- --------------------------------------------- ---------- --------------- -------------------------------------------------
3526 HS message to agent -1 895 WAITED SHORT TIME
Regards
Edited by: 937853 on Jul 31, 2012 2:20 PM