Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_REFRESH

All the refresh groups

Columns
   ___________________________
 
   ROWNER
      Name of the owner of the refresh group
   RNAME
      Name of the refresh group
   REFGROUP
      Internal identifier of refresh group
   IMPLICIT_DESTROY
      Y or N,if Y then destroy the refresh group when its last item is subtracted
   PUSH_DEFERRED_RPC
      Y or N,if Y then push changes from snapshot to master before refresh
   REFRESH_AFTER_ERRORS
      If Y,proceed with refresh despite error when pushing deferred RPCs
   ROLLBACK_SEG
      Name of the rollback segment to use while refreshing
   JOB
      Identifier of job used to automatically refresh the group
   NEXT_DATE
      Date that this job will next be automatically refreshed,if not broken
   INTERVAL
      A date function used to compute the next NEXT_DATE
   BROKEN
      Y or N,Y is the job is broken and will never be run
   PURGE_OPTION
      The method for purging the transaction queue after each push
   PARALLELISM
      The level of parallelism for transaction propagation
   HEAP_SIZE
      The heap size used for transaction propagation

Related:



Simon Sheppard
SS64.com