Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, A Reader.

Asked: November 10, 2016 - 2:07 am UTC

Last updated: November 10, 2016 - 3:15 pm UTC

Version: 10gR1

Viewed 1000+ times

You Asked

Hi
I am creating the Materialized view using COMPLETE REFRESH.
how do I see the progress of the operation ? %age complete etc
session longops is not showing as it depends on the operation type


regards

and Chris said...

I'm not aware of a direct way to do this. A complete refresh runs a number of statements. So even if you can see the longops, they only relate to the current part of the refresh.

If you're licensed to use the SQL monitor (diagnostics and tuning packs) and on 11g+ you could use this to check what it's currently doing.

https://oracle-base.com/articles/11g/real-time-sql-monitoring-11gr1

Is this answer out of date? If it is, please let us know via a Comment