MVIEW refresh complete very slow (for Ivan78)
Hi Maiden,
happy new year
I have the same problem again. I am waiting the refresh from about 60 minute. I have generated the trace file with this information:
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 3 0.00 0.00
library cache pin 2 0.00 0.00
enq: MS - contention 332 5.04 1607.80
latch: ges resource hash list 29 0.00 0.00
row cache lock 11 0.00 0.00
********************************************************************************
Could you help me to understand because i have 1607 second from wait?