 |
|
DBMS_AQ_INV package tips
Oracle Tips by Burleson Consulting |
DBMS_AQ_INV
<< Return to the index
Related notes on DBMS_AQ_INV:
Oracle 11g provides the following information about the DBMS_AQ_INV package:
Description of the DBMS_AQ_INV package:
PROCEDURE DBMS_AQ_INV.CREATE_PROC_BUFFERED_MCQ
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PROC_NAME VARCHAR2 IN
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
INVOKER VARCHAR2 IN
PROCEDURE DBMS_AQ_INV.CREATE_PROC_BUFFERED_SCQ
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PROC_NAME VARCHAR2 IN
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
INVOKER VARCHAR2 IN
PROCEDURE DBMS_AQ_INV.DELETE_PURGE_ELIGIBLE_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
SUB_ID_ARR TABLE OF NUMBER IN
ENQ_TIME_ARR TABLE OF TIMESTAMP IN
STEP_NO_ARR TABLE OF NUMBER IN
MSG_PRTY_ARR TABLE OF NUMBER IN
CHAIN_NO_ARR TABLE OF NUMBER IN
LOCAL_ORDER_NO_ARR TABLE OF NUMBER IN
MSG_ID_ARR TABLE OF RAW(16) IN
QT_SORT_COLS NUMBER IN
PROCEDURE DBMS_AQ_INV.GET_PAYLOAD_TYPE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
PAYLOAD_TYPE VARCHAR2 OUT
PROCEDURE DBMS_AQ_INV.INTERNAL_PURGE_QUEUE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
QT_FLAGS BINARY_INTEGER IN
TOBJNO BINARY_INTEGER IN
QT_SORT_COLS BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
PURGE_CONDITION VARCHAR2 IN
INVOKER VARCHAR2 IN
PROCEDURE DBMS_AQ_INV.PURGE_BUFFERED_MCQ_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
QT_OBJNO NUMBER IN
QT_FLAGS NUMBER IN
PURGE_CONDITION VARCHAR2 IN
INVOKER VARCHAR2 IN
PROCEDURE DBMS_AQ_INV.PURGE_BUFFERED_SCQ_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
QT_OBJNO VARCHAR2 IN
PURGE_CONDITION VARCHAR2 IN
INVOKER VARCHAR2 IN
PROCEDURE DBMS_AQ_INV.PURGE_PERSISTENT_MCQ_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
PURGE_CONDITION VARCHAR2 IN
QT_FLAGS NUMBER IN
QT_SORT_COLS NUMBER IN
PROCEDURE DBMS_AQ_INV.PURGE_PERSISTENT_SCQ_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
PURGE_CONDITION VARCHAR2 IN
FUNCTION DBMS_AQ_INV.PURGE_PROCEDURE_NAME RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_OBJNO NUMBER IN
IS_MCQ BOOLEAN IN
PROCEDURE DBMS_AQ_INV.WRITE_TRACE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MESSAGE VARCHAR2 IN
EVENT_LEVEL BINARY_INTEGER IN DEFAULT
TIME_INFO BOOLEAN 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
|
|
