Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_SNAPSHOTS

Snapshots the user can access

Columns
   ___________________________
 
   OWNER
      Owner of the snapshot
   NAME
      The view used by users and applications for viewing the snapshot
   TABLE_NAME
      Table the snapshot is stored in -- has an extra column for the master rowid
   MASTER_VIEW
      View of the master table,owned by the snapshot owner,used for refreshes
   MASTER_OWNER
      Owner of the master table
   MASTER
      Name of the master table that this snapshot is a copy of
   MASTER_LINK
      Database link name to the master site
   CAN_USE_LOG
      If NO,this snapshot is complex and will never use a log
   UPDATABLE
      If NO,the snapshot is read only. Look up REPLICATION
   REFRESH_METHOD
      The values used to drive a fast refresh of the snapshot
   LAST_REFRESH
      SYSDATE from the master site at the time of the last refresh
   ERROR
      The error returned last time an automatic refresh was attempted
   FR_OPERATIONS
      --
   CR_OPERATIONS
      --
   TYPE
      The type of refresh (complete,fast,force) for all automatic refreshes
   NEXT
      The date function used to compute next refresh dates
   START_WITH
      The date function used to compute next refresh dates
   REFRESH_GROUP
      All snapshots in a given refresh group get refreshed in the same transaction
   UPDATE_TRIG
      The name of the trigger which fills the UPDATE_LOG
   UPDATE_LOG
      The table which logs changes made to an updatable snapshots
   QUERY
      The original query that this snapshot is an instantiation of
   MASTER_ROLLBACK_SEG
      Rollback segment to use at the master site
   STATUS
      The status of the contents of the snapshot
   REFRESH_MODE
      This indicates how and when the snapshot will be refreshed
   PREBUILT
      If YES,this snapshot uses a prebuilt table as the base table

Related:

 DBA_RGROUP
 DBA_RCHILD 
 DBA_REFRESH



Simon Sheppard
SS64.com