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
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