Re: Mviews Refresh Timings
From: <lyxx09_at_gmail.com>
Date: Mon, 9 Mar 2009 06:18:17 -0700 (PDT)
Message-ID: <8476d291-d57f-4cd2-9c5b-ac47c1fb093b_at_r34g2000vba.googlegroups.com>
Hi David -
Date: Mon, 9 Mar 2009 06:18:17 -0700 (PDT)
Message-ID: <8476d291-d57f-4cd2-9c5b-ac47c1fb093b_at_r34g2000vba.googlegroups.com>
Hi David -
This job refresh 30+ Mviews which are based on Tables. Database 10.2.0.3 and this is Apps 11.5.10.2 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