Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_REFRESH_CHILDREN

All the objects in refresh groups,where the user owns the refresh group

Columns
   ___________________________
 
   OWNER
      Owner of the object in the refresh group
   NAME
      Name of the object in the refresh group
   TYPE
      Type of the object in the refresh group
   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