Oracle | DBMS_AQADM

Oracle DBMS_AQADM_VAR 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 Advanced Queuing Administration Utilities

AUTHID CURRENT_USER

Dependencies

DBMS_AQADM	DBMS_AQ_SYS_IMP_INTERNAL	DBMS_PRVTSQIS
DBMS_AQADM_INV	DBMS_PRVTAQIM	DBMS_RULE_EXIMP
DBMS_AQADM_SYS	DBMS_PRVTAQIP	DUAL
DBMS_AQADM_SYSCALLS	DBMS_PRVTAQIS	V$PARAMETER
DBMS_AQINT_LIB

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted.

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

Subprograms

DBCOMPATMAJOR	GETIDNLENGTH	ISLONGIDN
DBCOMPATMINOR	GET_DB_BLOCK_SIZE

DBCOMPATMAJOR

Returns the database major version dbms_aqadm_var.dbCompatMajor RETURN

SELECT dbms_aqadm_var.dbCompatMajor

      FROM dual;

      

      DBCOMPATMAJOR

      -------------

                 21

DBCOMPATMINOR

Returns the database minor version dbms_aqadm_var.dbCompatMinor RETURN

SELECT dbms_aqadm_var.dbCompatMinor

      FROM dual;

      

      DBCOMPATMINOR

      -------------

                  0

GETIDNLENGTH

Undocumented but likely the maximum byte size of a queue name dbms_aqadm_var.getIDNLength RETURN NUMBER;

SELECT 
      dbms_aqadm_var.getIDNLength

      FROM dual;

      

      GETIDNLENGTH

      ------------

               128

GET_DB_BLOCK_SIZE

Returns the database block size dbms_aqadm_var.get_db_block_size RETURN NUMBER;

SELECT 
      dbms_aqadm_var.get_db_block_size

      FROM dual;

      

      GET_DB_BLOCK_SIZE

      -----------------

                   8192

ISLONGIDN

Undocumented dbms_aqadm_var.isLongIDN RETURN NUMBER;

SELECT dbms_aqadm_var.isLongIDN

      FROM dual;

      

       ISLONGIDN

      ----------

               1