PL/SQL (MOSC)

MOSC Banner

Refreshing Materialized view in 11g hangs

edited May 12, 2014 12:00PM in PL/SQL (MOSC) 6 commentsAnswered

Dw is the owner of the Materialized View.
Sowadw is the user that client uses to refresh this MV. She used to do this very fast in 9.2
Now in 11.2 is hanguing.
 
CREATE MATERIALIZED VIEW DW.DW_TBS_TASKS 
TABLESPACE DW_DATA
NOCACHE
LOGGING
NOPARALLEL
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
WITH PRIMARY KEY
ENABLE QUERY REWRITE
AS 
/* Formatted on 5/5/2014 8:07:41 AM (QP5 v5.185.11230.41888) */
SELECT DOCUMENT_NUMBER,
  TASK_NUMBER,
  TASK_STATUS,
  TASK_PRIORITY,
  SCHEDULED_COMPLETION_DATE,
  ACTUAL_COMPLETION_DATE,
  ESTIMATED_COMPLETION_DATE,
  LAST_MODIFIED_USERID,
  LAST_MODIFIED_DATE,
  TASK_TYPE,
  CIRCUIT_DESIGN_ID,
  WORK_QUEUE_ID,
  WORK_QUEUE_PRIORITY,
  ASSIGNED_FROM_WORK_QUEUE,

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