Database DataWarehousing (MOSC)

MOSC Banner

Materialized view refresh time

edited Dec 7, 2011 9:56AM in Database DataWarehousing (MOSC) 6 comments
I set up the materialized view for people to run some long running decision support queries. I pre-set the refresh intervals. But how can I find out how long does it take for the refresh group from start of the refresh to actually finish the refresh? I did use the fast refresh. I have about 40 materialized views in one refresh group though.  I can find out the refresh start time by querying the next_date in the dba_jobs, but where can I find the info for the finish time? Gurus, any idea? Thanks. By the way, this is a 10.2.0.3 version

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