 |
|
DBMS_AQADM_SYSCALLS package tips
Oracle Tips by Burleson Consulting |
DBMS_AQADM_SYSCALLS
<< Return to the index
Oracle 11g provides the following information about the DBMS_AQADM_SYSCALLS package:
Description of the DBMS_AQADM_SYSCALLS package:
FUNCTION DBMS_AQADM_SYSCALLS.GET_OWNER_INSTANCE RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PRIMARY_INSTANCE BINARY_INTEGER IN
SECONDARY_INSTANCE BINARY_INTEGER IN
CURR_OWNER_INSTANCE BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.GET_WATERMARK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
WMVALUE NUMBER OUT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_ADDSUBSCRIBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
Q_SCHEMA VARCHAR2 IN
Q_NAME VARCHAR2 IN
SUB AQ$_AGENT IN
SUB_TYPE NUMBER IN
RULE VARCHAR2 IN DEFAULT
TRANS_OWNER VARCHAR2 IN DEFAULT
TRANS_NAME VARCHAR2 IN DEFAULT
RULESET_OWNER VARCHAR2 IN DEFAULT
RULESET_NAME VARCHAR2 IN DEFAULT
NEGRSET_OWNER VARCHAR2 IN DEFAULT
NEGRSET_NAME VARCHAR2 IN DEFAULT
SUB_ID NUMBER IN DEFAULT
PROXY_ID NUMBER IN DEFAULT
PROXY_ADDR VARCHAR2 IN DEFAULT
ADDR_ID NUMBER IN DEFAULT
CREATION_TIME TIMESTAMP WITH TIME ZONE IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_ALTERCACHEOBJECT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
JOBNAME VARCHAR2 IN
DURATION NUMBER IN
LATENCY NUMBER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_ALTERQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
MAX_RETRY BINARY_INTEGER IN DEFAULT
RETRY_INTERVAL BINARY_INTEGER IN DEFAULT
RETENTION BINARY_INTEGER IN DEFAULT
COMMENT VARCHAR2 IN DEFAULT
FLOW_CONTROL BINARY_INTEGER IN DEFAULT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_ALTERSUBSCRIBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
Q_SCHEMA VARCHAR2 IN
Q_NAME VARCHAR2 IN
SUB AQ$_AGENT IN
NEW_RULE_NAME VARCHAR2 IN DEFAULT
EX_RULE_NAME VARCHAR2 IN DEFAULT
NEW_TRANS_NAME VARCHAR2 IN DEFAULT
FULL_RULESET VARCHAR2 IN DEFAULT
EX_RULESET VARCHAR2 IN DEFAULT
FULL_NEGRSET VARCHAR2 IN DEFAULT
EX_NEGRSET VARCHAR2 IN DEFAULT
MODIFICATION_TIME TIMESTAMP WITH TIME ZONE IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_BEGINTRANS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SET_NOCMT BOOLEAN IN DEFAULT
OLD_STATE BOOLEAN OUT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_CHECKQUEPRIV
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
Q_SCHEMA VARCHAR2 IN
Q_NAME VARCHAR2 IN
PRIV BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_CHECKSYSPRIV
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ_SCHEMA VARCHAR2 IN
SYSPRIV BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_CREATECACHEOBJECT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DESTINATION VARCHAR2 IN
JOBNAME VARCHAR2 IN
DURATION NUMBER IN
MYOID RAW IN
LATENCY NUMBER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_CREATEQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
TABLE_NAME VARCHAR2 IN
COMPATIBLE BINARY_INTEGER IN
QUEUE_OID RAW IN
QUEUE_TYPE BINARY_INTEGER IN
MAX_RETRY BINARY_INTEGER IN DEFAULT
RETRY_INTERVAL BINARY_INTEGER IN DEFAULT
TRACKING BOOLEAN IN DEFAULT
RETENTION BINARY_INTEGER IN
OWNER_INSTANCE BINARY_INTEGER IN
COMMENT VARCHAR2 IN DEFAULT
QT_FLAGS BINARY_INTEGER IN
TIMEZONE VARCHAR2 IN DEFAULT
CREATE_IMPORT BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_DESTROYCACHEOBJECT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
JOBNAME VARCHAR2 IN
DEST VARCHAR2 IN
MYOID RAW IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_DMPESTACK
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_DROPQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
FORCE BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_DROPREGISTRATIONS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QNAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_ENDTRANS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
COMMIT_TRANS BOOLEAN IN DEFAULT
OLD_STATE BOOLEAN IN DEFAULT
FUNCTION DBMS_AQADM_SYSCALLS.KWQA_3GL_EVENTLEVEL RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
EVENT BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_EXECUTESTMT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
STMT VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_FIND_DATE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INTERVAL VARCHAR2 IN
NEXT_DATE DATE OUT
FUNCTION DBMS_AQADM_SYSCALLS.KWQA_3GL_GETOSTIMEZONE RETURNS VARCHAR2
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_GRANT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
GRANTEE VARCHAR2 IN
PRIVILEGE BINARY_INTEGER IN
IS_SYSPRIV BOOLEAN IN
CASCADE BOOLEAN IN
GRANTOR VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_INVALIDATEQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
Q_NAME VARCHAR2 IN
FUNCTION DBMS_AQADM_SYSCALLS.KWQA_3GL_ISSTREAMSCAPTUREOFF RETURNS BOOLEAN
FUNCTION DBMS_AQADM_SYSCALLS.KWQA_3GL_ISTTSIMPORT RETURNS BOOLEAN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_LOCKQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
Q_SCHEMA VARCHAR2 IN
Q_NAME VARCHAR2 IN
OPERATION VARCHAR2 IN
FLAGS BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_LOCKQUEUETABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
OPERATION VARCHAR2 IN
FLAGS BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_LOCKQUEUETABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
OPERATION VARCHAR2 IN
FLAGS BINARY_INTEGER IN
QTAB_EXISTS BOOLEAN OUT
QTDCT_EXISTS BOOLEAN OUT
QTOBJNO BINARY_INTEGER OUT
QT_FLAGS BINARY_INTEGER OUT
QT_OWNER BINARY_INTEGER OUT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_NFYNOI
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QTOBJNO BINARY_INTEGER IN
INSTID BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_PARSEAQNAME
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NTYPE BINARY_INTEGER IN
FNAME VARCHAR2 IN
DEFAULT_SCHEMA VARCHAR2 IN
SCHEMA VARCHAR2 OUT
NAME VARCHAR2 OUT
DBLKDB VARCHAR2 OUT
DBLKDOM VARCHAR2 OUT
EXT_FLAG BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_PRINTREMSUBLIST
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_PURGEREMSUBLIST
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
SUB AQ$_AGENT IN
SUBID NUMBER IN
IFCHECK BOOLEAN IN
PENDINGTXNX BOOLEAN OUT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_PURGESCHEMASUBTAB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
TABLE_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_PURGE_QUEUE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
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
FUNCTION DBMS_AQADM_SYSCALLS.KWQA_3GL_QT_COMPAT RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
COMPATIBLE VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_REMOVESUBSCRIBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
Q_SCHEMA VARCHAR2 IN
Q_NAME VARCHAR2 IN
SUB AQ$_AGENT IN
RULE_NAME VARCHAR2 IN DEFAULT
RULESET VARCHAR2 IN DEFAULT
NEGRSET VARCHAR2 IN DEFAULT
SUBID NUMBER IN DEFAULT
PROXYID NUMBER IN DEFAULT
DELETION_TIME TIMESTAMP WITH TIME ZONE IN
SCN_AT_REMOVE NUMBER OUT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_REVOKE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
GRANTEE VARCHAR2 IN
PRIVILEGE BINARY_INTEGER IN
IS_SYSPRIV BOOLEAN IN
GRANTOR VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_SCHEDULETMSERVICE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_OBJN BINARY_INTEGER IN
OWNER_INSTANCE BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_SETMSGWAIT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PROCNAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_SETREGISTRATIONNAME
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
REGNAME VARCHAR2 OUT
QSCHEMA VARCHAR2 IN
QNAME VARCHAR2 IN
DEST VARCHAR2 IN
DELIM VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_SETSTREAMSCAPTUREOFF
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CAPTURE_OFF BOOLEAN IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_SET_TABLE_STATS_LOCK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNNAME VARCHAR2 IN
OBJNAME VARCHAR2 IN
OBJSUBNAME VARCHAR2 IN
DSLCKMODE BINARY_INTEGER IN
CSLCKMODE BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_SET_VIEW_FLAG
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
VIEW_SCHEMA VARCHAR2 IN
VIEW_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_STARTQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
ENQUEUE BOOLEAN IN
DEQUEUE BOOLEAN IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_STOPQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
ENQUEUE BOOLEAN IN
DEQUEUE BOOLEAN IN
WAIT BOOLEAN IN
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_UPDKGQM
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QID BINARY_INTEGER IN
QSCHEMA VARCHAR2 IN
QNAME VARCHAR2 IN
FLOW_CONTROL BINARY_INTEGER IN
OP BINARY_INTEGER IN
FORCE BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYSCALLS.KWQA_3GL_VALIDATEQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
Q_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYSCALLS.SET_WATERMARK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
WMVALUE NUMBER 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
|
|
