Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_SNAPSHOTS

All snapshots in the database

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 number of failed automatic refreshes since last successful refresh
   FR_OPERATIONS
      If REGENERATE,then the fast refresh operations have not been generated
   CR_OPERATIONS
      If REGENERATE,then the complete refresh operations have not been generated
   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