determine next refresh time for snapshot
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: determine next refresh time for snapshot

  1. #1
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227

    determine next refresh time for snapshot

    Hi,

    How can I find out the next refresh date for a materialized view that is refreshed forced on demand. The materialized view was created using build immediate. The data dictionary view MVIEWS mentioned only last refresh time which in this case is the same as the date I created the materialized view.

    Thanks,
    L
    leonard905
    leonard905@yahoo.com

  2. #2
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    SQL Script ... Run from SQLPlus

    set linesize 100
    select substr(s.name,1,20),error,refresh_method,fr_operations "Fast Refresh",
    cr_operations "Complete Refresh",type,
    to_char(t.last_refresh,'DD-MON-YY HH24:MI:SS') "Next Refresh"
    from all_snapshots s, all_snapshot_refresh_times t
    where type = 'FAST'
    and s.name = t.name
    order by t.last_refresh desc
    ;

    Gregg

  3. #3
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    Thanks. But I looked at all_snapshots and the ones with a refresh_mode of "DEMAND" have blank NEXT columns. Any ideas why?

    Thanks,
    L
    leonard905
    leonard905@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width