Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_SNAPSHOT_REFRESH_TIMES

Snapshots and their last refresh times for each master table that the user can look at

Columns
   ___________________________
 
   NAME
      The view used by users and applications for viewing the snapshot
   OWNER
      Owner of the snapshot
   MASTER
      Name of the master table
   MASTER_OWNER
      Owner of the master table
   LAST_REFRESH
      SYSDATE from the master site at the time of the last refresh

Related Commands:




Back to the Top

Simon Sheppard
SS64.com