Oracle | DBMS

Oracle DBMS_TEQK Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented Advanced Queuing related internal package. About the only thing we can find that might give a hint to its purpose is the following:

SQL> desc dba_queue_partition_assignment_table ERROR: ORA-04043: object dba_queue_partition_assignment_table does not exist SQL> desc dba_queue_partition_assignment_table ERROR: ORA-04043: object dba_queue_partition_assignment_table does not exist SQL> desc all_queue_partition_assignment_table ERROR: ORA-04043: object all_queue_partition_assignment_table does not exist SQL> desc user_queue_partition_assignment_table Name Null? Type ------------------ -------- -------------------------- OWNER NOT NULL VARCHAR2(128) QUEUE_ID NOT NULL NUMBER QUEUE_NAME NOT NULL VARCHAR2(128) SUBSCRIBER_ID NOT NULL NUMBER SUBSCRIBER_NAME NOT NULL VARCHAR2(128) SESSION_ID NOT NULL NUMBER GROUP_LEADER NOT NULL NUMBER PARTITION_ID NUMBER VERSION# NUMBER INST_ID NOT NULL NUMBER FLAGS NUMBER CLIENT_ID VARCHAR2(128) CLIENT_VERSION VARCHAR2(128) AUDIT_SID NUMBER CREATE_TIME TIMESTAMP(6) WITH TIME ZONE

and the most interesting thing about it is that there isn't a CDB, DBA, or ALL version of the view.

AUTHID CURRENT_USER

Data Types TYPE partition_list ....

Dependencies

AQ$_QPAT_INFO	DBMS_AQADM_SYSCALLS	DUAL
AQ$_QPAT_INFO_LIST	DBMS_AQ_LIB	PLITBLM
AQ$_QPIM_INFO	DBMS_LOCK	USER_QUEUE_PARTITION_ASSIGNMENT_TABLE
AQ$_QPIM_INFO_LIST	DBMS_SYS_ERROR	USER_QUEUE_SHARDS
DBMS_AQADM

Documented No

First Available 20c

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsteqk.plb

Subprograms

AQ$_CONNECT_ME

AQ$_JOIN_GROUP

AQ$_SYNC

AQ$_CONNECT_ME (new 20c)

Undocumented dbms_teqk.aq$_connect_me( schema IN VARCHAR2, queue_name IN VARCHAR2, subscriber_name IN VARCHAR2, inst_id OUT NUMBER, url OUT NUMBER, flags IN OUT NUMBER, p_list OUT sys.dbms_teqk.partition_list);

TBD

AQ$_JOIN_GROUP (new 20c)

Undocumented dbms_teqk.aq$_join_group( qpat_list IN OUT sys.aq$_qpat_info_list, qpim_list OUT sys.aq$_qpat_info_list, shard_num OUT NUMBER, version# OUT NUMBER);

TBD

AQ$_SYNC (new 20c)

Undocumented dbms_teqk.aq$_sync( QPAT_LIST IN OUT sys.aq$_qpat_info_list, version# IN OUT NUMBER);

TBD