Hello Team,
I have a job contains next block to refresh materialized view on a daily basis but we are not sure how much time it's required to get the refresh.
BEGIN
DBMS_SNAPSHOT.REFRESH ('V_TAB_STILLDESC_MV', 'C');
END;
So my requirement is, I have to create 1 table that contains(stores) a log of start time and finish time to get this materialized view refresh. So how I can achieve this, please help me.
Thanks