Setting the Apply Parameters

NOTE: The parameter value is always entered as a VARCHAR2 even if the parameter value is a number.

How can the DBA see what parameters are currently set for an Apply process? The dba_apply_parameters view can be used to list the parameters set for a particular Apply process.

The following SQL statement displays the current setting for each Apply process parameter:

col apply_name format a12
col PARAMETER format a25
col value format a20
 
SELECT APPLY_NAME,PARAMETER,VALUE, SET_BY_USER
FROM DBA_APPLY_PARAMETERS;
/

APPLY_NAME   PARAMETER                 VALUE                SET
------------ ------------------------- -------------------- ---
LN4_APPLY    PARALLELISM               3                    YES
LN4_APPLY    STARTUP_SECONDS           0                    NO