Database DataWarehousing (MOSC)

MOSC Banner

MVIEW refresh complete very slow (for Ivan78)

edited Jan 11, 2013 7:19AM in Database DataWarehousing (MOSC) 4 commentsAnswered
I posting this as a continuation of the thread started by Ivan78 because that thread has become unreadable and I cannot answer the question. The question was:

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center