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

VIEW: SYS.DBA_RGROUP

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

All refresh groups. This view is not a join.

[View Source]

Columns
Name Datatype Length Mandatory Comments
REFGROUP NUMBER

Internal identifier of refresh group
OWNER VARCHAR2 (128) Yes Owner of the refresh group
NAME VARCHAR2 (128) Yes Name of the 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
Yes Identifier of job used to automatically refresh the group
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 REFGROUP
,      OWNER
,      NAME
,      IMPLICIT_DESTROY
,      PUSH_DEFERRED_RPC
,      REFRESH_AFTER_ERRORS
,      ROLLBACK_SEG
,      JOB
,      PURGE_OPTION
,      PARALLELISM
,      HEAP_SIZE
FROM SYS.DBA_RGROUP;

Dependencies

[top of page]

SYS.DBA_RGROUP references the following:

SchemaSYS
TableRGROUP$
SYS.DBA_RGROUP is referenced by following:

SchemaPUBLIC
SynonymDBA_RGROUP