Oracle DBMS

Oracle DBMS_TEQK Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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