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 will be available on generic Linux platforms in January and soon on AIX and Windows

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