Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck
 

 

   
 

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

 

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.