Oracle DBMS_AQADM_VAR
Version 18.3

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_SYS DBMS_PRVTAQIP DBMS_RULE_EXIMP
DBMS_AQADM_SYSCALLS DBMS_PRVTAQIS DUAL
DBMS_PRVTAQIM DBMS_PRVTSQIS V$PARAMETER
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/dbmsaqds.plb
Subprograms
 
DBCOMPATMAJOR (new 18c)
Returns the database major version dbms_aqadm_var.dbCompatMajor RETURN
SQL> SELECT dbms_aqadm_var.dbCompatMajor
  2  FROM dual;

DBCOMPATMAJOR
-------------
           18
 
DBCOMPATMINOR (new 18c)
Returns the database minor version dbms_aqadm_var.dbCompatMinor RETURN
SQL> SELECT dbms_aqadm_var.dbCompatMinor
  2  FROM dual;

DBCOMPATMINOR
-------------
            0
 
GETIDNLENGTH
Undocumented but likely the maximum byte size of a queue name dbms_aqadm_var.getIDNLength RETURN NUMBER;
SQL> SELECT dbms_aqadm_var.getIDNLength
  2  FROM dual;

GETIDNLENGTH
------------
         128
 
GET_DB_BLOCK_SIZE
Returns the database block size dbms_aqadm_var.get_db_block_size RETURN NUMBER;
SQL> SELECT dbms_aqadm_var.get_db_block_size
  2  FROM dual;

GET_DB_BLOCK_SIZE
-----------------
             8192
 
ISLONGIDN
Undocumented dbms_aqadm_var.isLongIDN RETURN NUMBER;
SQL> SELECT dbms_aqadm_var.isLongIDN
  2  FROM dual;

 ISLONGIDN
----------
         1

Related Topics
Advanced Queuing Demo 1
Advanced Queuing RAC Demo
Built-in Functions
Built-in Packages
DBMS_ALERT
DBMS_AQ
DBMS_AQADM
DBMS_AQELM
DBMS_AQIN
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_IMP_ZECURITY
DBMS_JOB
DBMS_SERVER_ALERT
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx