Database DataWarehousing (MOSC)

MOSC Banner

Create Materialized View takes very long

edited Nov 14, 2013 9:14AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi All,
As part of ETL job, we run the procedure which drops & recreates the materialized view which takes more 7 hrs.
Unfortunately, am unable to find the sql id of this create materialized command as i could find only sql id of procedure which is executing this mv.
I could not tune the sql id of procedure, not sure how to trace the create materialized view sql id and see what is current execution plan and see if we can tune

Can some body quickly help me on this???

DB Version: 10.2.0.4

Thanks 

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center