Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_SNAPSHOT_REFRESH_TIMES

All fast refreshable snapshots and their last refresh times for each master table

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com