Dave,
Unfortunately that info is not currently stored
anywhere. You can find out when the refresh began, by
checking dba_snapshot_refresh_times (there's a bug
where the time in dba_snapshots is listed as some time
in 1950).
You'll be happy to know that 9i will include some new
views that will
Wow, I thought I just wasn't looking hard enough. It's seems obvious that
we'd want to see when the refreshes finished. I'll take your advice and
wrap the call.
Thanks, Dave
On Mon, Jun 11, 2001 at 10:30:25AM -0700, A. Bardeen wrote:
Dave,
Unfortunately that info is not currently stored
Anyone know of the top of their head where I find when a snapshot's refresh
completed? I looked at total_time in dba_jobs but this appears to be cummulative.
Thanks, Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Turner
INET: [EMAIL PROTECTED]
Fat City