Here is the entry in v$session_wait. But i am not able to understand the reason for waiting...
PHP Code:SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SECONDS_IN_WAIT STATE
19 80 enqueue name|mode 1415053316 54580004 id1 655392 000A0020 id2 4,522 000011AA 0 0 WAITING




Reply With Quote