 |
|
DBMS_ASYNCRPC_PUSH package tips
Oracle Tips by Burleson Consulting |
DBMS_ASYNCRPC_PUSH
<< Return to the index
Oracle 11g provides the following information about the DBMS_ASYNCRPC_PUSH package:
Description of the DBMS_ASYNCRPC_PUSH package:
FUNCTION DBMS_ASYNCRPC_PUSH.CHECK_DATABASE_CAPABILITY RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NODENAME VARCHAR2 IN
USERID BINARY_INTEGER IN
CAPABILITY BINARY_INTEGER IN
PROCEDURE DBMS_ASYNCRPC_PUSH.ERROR_CALL_POSITION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NODENAME VARCHAR2 IN
USERID BINARY_INTEGER IN
POSITION BINARY_INTEGER OUT
FUNCTION DBMS_ASYNCRPC_PUSH.GET_CLOCK_TIME RETURNS NUMBER
FUNCTION DBMS_ASYNCRPC_PUSH.GET_SCN RETURNS NUMBER
FUNCTION DBMS_ASYNCRPC_PUSH.PROPAGATE_PARALLEL RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_QUEUE VARCHAR2 IN
USERID BINARY_INTEGER IN
STOP_ON_ERROR BOOLEAN IN
NEW_TXN_COUNT BINARY_INTEGER IN
STARTUP_SECONDS BINARY_INTEGER IN
EXECUTION_SECONDS BINARY_INTEGER IN
DELAY_SECONDS BINARY_INTEGER IN
NUM_THREADS BINARY_INTEGER IN
HEAP_SIZE BINARY_INTEGER IN
WRITE_TRACE BOOLEAN IN
DELIVERY_ORDER_LIMIT NUMBER IN DEFAULT
CATCHUP RAW IN DEFAULT
PROCEDURE DBMS_ASYNCRPC_PUSH.PROPAGATE_SERIAL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE VARCHAR2 IN
USERID BINARY_INTEGER IN
STOP_ON_ERROR BOOLEAN IN
NEW_TXN_COUNT BINARY_INTEGER IN
EXECUTION_SECONDS BINARY_INTEGER IN
DELAY_SECONDS BINARY_INTEGER IN
TXN_BATCH_SIZE BINARY_INTEGER IN
FUNCTION DBMS_ASYNCRPC_PUSH.PURGE_PARALLEL RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
METHOD BINARY_INTEGER IN
ROLLBACK_SEGMENT VARCHAR2 IN
EXECUTION_SECONDS BINARY_INTEGER IN/OUT
DELAY_SECONDS BINARY_INTEGER IN
WRITE_TRACE BOOLEAN IN
TRANSACTION_COUNT BINARY_INTEGER IN/OUT
FUNCTION DBMS_ASYNCRPC_PUSH.PUSH_PENDING_CALLS RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUERY_TYPE BINARY_INTEGER IN
NODENAME VARCHAR2 IN
USERID BINARY_INTEGER IN
BUFFER_SIZE BINARY_INTEGER IN
TID VARCHAR2 IN
CALL_TYPE BINARY_INTEGER IN
PROCEDURE DBMS_ASYNCRPC_PUSH.STAMP_QUEUE_BATCH
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCN_LIMIT NUMBER OUT
PROCEDURE DBMS_ASYNCRPC_PUSH.UPDATE_PURGE_STATISTICS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TXNSPURGED BINARY_INTEGER IN
 |
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
|
|