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 (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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AQ
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx