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.
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);