Oracle 18cR3 DBMSZEXP

Oracle DBMSZEXP_SYSPKGGRNT Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

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 Generates the SQL for DBMS_UTILITY.EXEC_DDL_STATEMENT to grant EXECUTE on DBMS_AQADM to the AQ_ADMINISTRATOR_ROLE role

AUTHID DEFINER

Dependencies

DBMS_ASSERT

DBMS_STANDARD

DBMS_ZHELP

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to EXECUTE_CATALOG_ROLE and EXP_FULL_DATABASE roles.

Source {ORACLE_HOME}/rdbms/admin/prvtzexp.plb

SYSTEM_INFO_EXP

Generate SQL to create grant dbmszexp_syspkggrnt( prepost IN BINARY_INTEGER, connectstring OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       retVal  VARCHAR2(128);

       cstring VARCHAR2(128);

       nblock  PLS_INTEGER;

      BEGIN

        retVal := dbmszexp_syspkggrnt.system_info_exp(1, cstring, '12.1', nblock);

        dbms_output.put_line(retVal);

        dbms_output.put_line(cstring);

        dbms_output.put_line(TO_CHAR(nblock));

      END;

      /