Oracle | DBMS_AQADM

Oracle DBMS_AQADM_VAR Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Advanced Queuing Administration Utilities

AUTHID CURRENT_USER

Dependencies

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

Returns the database major version dbms_aqadm_var.dbCompatMajor RETURN NUMBER;

SELECT dbms_aqadm_var.dbCompatMajor;

      

      DBCOMPATMAJOR

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

                 23

Returns the database minor version dbms_aqadm_var.dbCompatMinor RETURN NUMBER;

SELECT dbms_aqadm_var.dbCompatMinor;

      

      DBCOMPATMINOR

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

                  0

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

SELECT dbms_aqadm_var.getIDNLength;

      

      GETIDNLENGTH

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

               128

Returns the database block size dbms_aqadm_var.get_db_block_size RETURN NUMBER;

SELECT dbms_aqadm_var.get_db_block_size;

      

      GET_DB_BLOCK_SIZE

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

                   8192

Undocumented dbms_aqadm_var.isLongIDN RETURN NUMBER;

SELECT dbms_aqadm_var.isLongIDN;

      

       ISLONGIDN

      ----------

               1