[Home] [Help] [Dependency Information]
Object Name: | DBA_REFRESH |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All the refresh groups
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 |
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;
|
|
|