Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_REFRESH

All the refresh groups

Columns
   ___________________________
 
   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
   PUSH_DEFERRED_RPC
      Y or N, if Y then push changes from snapshot to master before refresh
   JOB
      Identifier of job used to automatically refresh the group
   ROWNER
      Name of the owner of the refresh group
   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
   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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com