DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_REFRESH

Object Details
Object Name: DBA_REFRESH
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All the refresh groups

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROWNER VARCHAR2 (128) Yes Name of the owner of the refresh group
RNAME VARCHAR2 (128) Yes Name of the refresh group
REFGROUP NUMBER

Internal identifier of refresh group
IMPLICIT_DESTROY VARCHAR2 (1)
Y or N, if Y then destroy the refresh group when its last item is subtracted
PUSH_DEFERRED_RPC VARCHAR2 (1)
Y or N, if Y then push changes from snapshot to master before refresh
REFRESH_AFTER_ERRORS VARCHAR2 (1)
If Y, proceed with refresh despite error when pushing deferred RPCs
ROLLBACK_SEG VARCHAR2 (128)
Name of the rollback segment to use while refreshing
JOB NUMBER

Identifier of job used to automatically refresh the group
NEXT_DATE DATE

Date that this job will next be automatically refreshed, if not broken
INTERVAL VARCHAR2 (200)
A date function used to compute the next NEXT_DATE
BROKEN VARCHAR2 (1)
Y or N, Y is the job is broken and will never be run
PURGE_OPTION NUMBER

The method for purging the transaction queue after each push
PARALLELISM NUMBER

The level of parallelism for transaction propagation
HEAP_SIZE NUMBER

The heap size used for transaction propagation
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROWNER
,      RNAME
,      REFGROUP
,      IMPLICIT_DESTROY
,      PUSH_DEFERRED_RPC
,      REFRESH_AFTER_ERRORS
,      ROLLBACK_SEG
,      JOB
,      NEXT_DATE
,      INTERVAL
,      BROKEN
,      PURGE_OPTION
,      PARALLELISM
,      HEAP_SIZE
FROM SYS.DBA_REFRESH;

Dependencies

[top of page]

SYS.DBA_REFRESH references the following:

SchemaSYS
TableJOB$
TableRGROUP$
SYS.DBA_REFRESH is referenced by following:

SchemaPUBLIC
SynonymDBA_REFRESH
SchemaSYS
ViewALL_REFRESH
Package BodyDBMS_REFRESH - show dependent code
ViewUSER_REFRESH