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
> 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 allow you to monitor a refresh as it's
> occurring, when it completed and to how long the
> refresh actually took.
>
> Until then, a workaround is to create your own PL/SQL
> wrapper to call the appropriate refresh routine and
> then afterwards populate a table or log with the
> current time.
>
> HTH,
>
> -- Anita
>
> --- David Turner <turner_at_tellme.com> wrote:
> > 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: turner_at_tellme.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Turner
INET: turner_at_tellme.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Jun 11 2001 - 12:27:47 CDT
