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 (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 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx