Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_REFRESH

All the refresh groups

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com