Mview Refresh Time.

Mview refresh is an important part of any Oracle Database Administrator daily routine.
There are times when we need to track the refresh times for various reasons or in case of troubleshooting any performance issue.
So, Oracle has a very good system table for monitoring the same.

DBA_MVIEW_ANALYSIS

For Complete Refresh, the refresh duration will be in the FULLREFRESHTIM column of the DBA_MVIEW_ANALYSIS.
For Fast Refresh duration, it will be in the INCREFRESHTIM column.
Both values are in seconds.