Re: Mviews Refresh Timings
Date: Mon, 9 Mar 2009 06:18:17 -0700 (PDT)
Hi David -
This job refresh 30+ Mviews which are based on Tables. Database 10.2.0.3 and this is Apps 184.108.40.206 instance. Oracle seed mean this program/concurrent job comes with this release. I can not edit this program and store timings in one table for individual refresh.
DBA_MVIEW or sys.SNAP_REFRESH$$ has column when refresh was completed (last time) but not when it was started. Received on Mon Mar 09 2009 - 08:18:17 CDT