 |
|
DBMS_CAPTURE_SWITCH_INTERNAL package tips
Oracle Tips by Burleson Consulting |
DBMS_CAPTURE_SWITCH_INTERNAL
<< Return to the index
Oracle 11g provides the following information about the DBMS_CAPTURE_SWITCH_INTERNAL package:
Description of the DBMS_CAPTURE_SWITCH_INTERNAL package:
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.CAN_SWITCH
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_CAPTURE_NAME VARCHAR2 IN
SWITCH_TO_MODE VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.CAPTURE_WAIT_FOR_SCN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_CAPTURE_NAME VARCHAR2 IN
SCN NUMBER IN
WAIT_INTERVAL NUMBER IN DEFAULT
MAXWAIT NUMBER IN DEFAULT
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.DISPLAY_MESSAGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MSG VARCHAR2 IN
ALERT BOOLEAN IN DEFAULT
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.GET_APPLY_NAME_AND_DBLINK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_CAPTURE_NAME VARCHAR2 IN
CANON_APPLY_NAME VARCHAR2 OUT
DATABASE_LINK VARCHAR2 OUT
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.GET_DATABASE_SCNS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CURRENT_SCN NUMBER OUT
MIN_START_SCN NUMBER OUT
MESSAGE VARCHAR2 OUT
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.GET_OLDEST_SCN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_APPLY_NAME VARCHAR2 IN
OLDEST_SCN NUMBER OUT
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.RESTART_PROCESS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_PROCESS_NAME VARCHAR2 IN
PROCESS_TYPE VARCHAR2 IN
MAX_RESTART_ATTEMPTS NUMBER IN DEFAULT
WAIT_INTERVAL NUMBER IN DEFAULT
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.SET_OLDEST_SCN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_APPLY_NAME VARCHAR2 IN
SCN NUMBER IN
IS_RANGE BOOLEAN IN DEFAULT
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.WAITFOR_CAPTURE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_CAPTURE_NAME VARCHAR2 IN
ACTIVITY VARCHAR2 IN
WAIT_INTERVAL NUMBER IN DEFAULT
MAX_WAIT NUMBER IN DEFAULT
PROCEDURE DBMS_CAPTURE_SWITCH_INTERNAL.WAIT_CAPTURE_MAKE_PROGRESS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_CAPTURE_NAME VARCHAR2 IN
WAIT_INTERVAL NUMBER IN DEFAULT
MAXWAIT NUMBER IN DEFAULT
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
