Oracle | DBMS_AQADM

Oracle DBMS_AQADM_VAR Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

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

                 18

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