DBA_REPEXTENSIONS

The DBA_REPEXTENSIONS view contains information about current operations that are adding new master sites to a master group without quiescing the master group.

See Also:

"Adding New Master Sites Without Quiescing the Master Group" for information about the procedure that adds new master sites to a replication environment

Column	Datatype	NULL	Description
`EXTENSION_ID`	`RAW(16)`	`NOT NULL`	The identifier for a current pending request to add master databases to a master group without quiesce.
`REQUEST`	`VARCHAR2(15)`	-	Extension request type. Currently, the only possible value is `ADD_NEW_MASTERS`, which indicates a request to add new master sites to a master group without quiescing.
`MASTERDEF`	`VARCHAR2(128)`	-	The global name of the master definition site of the master groups to which new master sites are being added.
`EXPORT_REQUIRED`	`VARCHAR2(3)`	-	`YES` indicates that one or more new master sites will be added using export/import of either the entire database or at the table level. `NO` indicates that all new master sites will be added using change-based recovery.
`REPCATLOG_ID`	`NUMBER`	-	Identifier of replication catalog records related to a replication extension, on which the master definition site is waiting. This value is only meaningful at the master definition site.
`EXTENSION_STATUS`	`VARCHAR2(13)`	-	Status of each replication extension. This value is only meaningful at the master definition site. The possible values are: `READY`: The extension request has been created and is ready. `STOPPING`: The new master sites have been added to the master group and the master definition site is attempting to stop propagation from existing masters to new master sites and to the master definition site. `EXPORTING`: The propagation of deferred transactions has been stopped from existing master sites to new master sites and to the master definition site. The master definition site is waiting for the export to finish. `INSTANTIATING`: The `DBMS_REPCAT.RESUME_PROPAGATION_TO_MDEF` procedure has been invoked (if export was used), and the master definition site is waiting for the new masters to instantiate. `ERROR`: An error occurred during the execution of this extension request.
`FLASHBACK_SCN`	`NUMBER`	-	The system change number (SCN) that must be used during export or change-based recovery when the new master sites are added. The new master sites must be consistent with the SCN listed.
`BREAK_TRANS_TO_MASTERDEF`	`VARCHAR2(3)`	-	This value is meaningful only if `EXPORT_REQUIRED` is `TRUE`. If `BREAK_TRANS_TO_MASTERDEF` is `TRUE`, then existing masters may continue to propagate their deferred transactions to the master definition site for replication groups that are not adding master sites. Deferred transactions for replication groups that are adding master sites cannot be propagated until the export completes. If `BREAK_TRANS_TO_MASTERDEF` is `FALSE`, then existing masters cannot propagate any deferred transactions to the master definition site.
`BREAK_TRANS_TO_NEW_MASTERS`	`VARCHAR2(3)`	-	If `BREAK_TRANS_TO_NEW_MASTERS` is `TRUE`, then existing master sites may continue to propagate deferred transactions to the new master sites for replication groups that are not adding master sites. If `BREAK_TRANS_TO_NEW_MASTERS` is `FALSE`, then propagation of deferred transaction queues to the new masters is disabled.
`PERCENTAGE_FOR_CATCHUP_MDEF`	`NUMBER`	-	This value is meaningful only if `BREAK_TRANS_TO_MASTERDEF` is `TRUE`. The percentage of propagation resources that should be used for catching up propagation to the master definition site.
`CYCLE_SECONDS_MDEF`	`NUMBER`	-	This value is meaningful when `PERCENTAGE_FOR_CATCHUP_MDEF` is both meaningful and is a value between 10 and 90, inclusive. In this case, propagation to the master definition site alternates between replication groups that are not being extended and replication groups that are being extended, with one push to each during each cycle. This value indicates the length of the cycle in seconds.
`PERCENTAGE_FOR_CATCHUP_NEW`	`NUMBER`	-	This value is meaningful only if `BREAK_TRANS_TO_NEW_MASTERS` is `TRUE`. The percentage of propagation resources that should be used for catching up propagation to new master sites.
`CYCLE_SECONDS_NEW`	`NUMBER`	-	This value is meaningful when `PERCENTAGE_FOR_CATCHUP_NEW` is both meaningful and is a value between 10 and 90, inclusive. In this case, propagation to a new master alternates between replication groups that are not being extended and replication groups that are being extended, with one push to each during each cycle. This value indicates the length of the cycle in seconds.