For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
Purpose
Advanced Queuing payload handler for non-scalar data types
AUTHID
CURRENT_USER
Dependencies
DBMS_AQ_LIB
Documented
No
First Available
Not Known
Security Model
Owned by SYS with EXECUTE granted to GSMADMIN_INTERNAL and WMSYS
Source
{ORACLE_HOME}/rdbms/admin/dbmsaqds.plb
Subprograms
GET_ADT_PAYLOAD
GET_OPAQUE_PAYLOAD
GET_RAW_PAYLOAD
GET_ADT_PAYLOAD
Handler for ADT AQ message payloads
dbms_aq_bqview.get_adt_payload(
QID IN NUMBER,
MSGNO IN BINARY_INTEGER,
DUMMY IN sys.standard.<ADT_1>)
RETURN sys.standard.<ADT_1>;
TBD
GET_OPAQUE_PAYLOAD
Handler for OPAQUE AQ message payloads
dbms_aq_bqview.get_opaque_payload(
QID IN NUMBER,
MSGNO IN BINARY_INTEGER,
DUMMY IN XMLTYPE)
RETURN XMLTYPE;
TBD
GET_RAW_PAYLOAD
Handler for RAW AQ message payloads
dbms_aq_bqview.get_raw_payload(
QID IN NUMBER,
MSGNO IN BINARY_INTEGER)
RETURN BLOB;
