Oracle | UTL_RPA

Oracle UTL_RPA_ADM Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Replication Performance Advisor utility ADMinistration

This package is not automatically installed in version 20c and above

AUTHID CURRENT_USER

Dependencies

DBMS_STANDARD

UTL_RPA_ADM_INT

UTL_RPA_ADM_INT_INVOK

Documented No

First Available 19c

Security Model Owned by a schema, cannot be SYS, with the SELECT ANY DICTIONARY. After installation no privileges are granted on the package.

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

SQL> / as sysdba

      

      CREATE USER c##rpadv IDENTIFIED BY apv

      DEFAULT TABLESPACE sysaux

      TEMPORARY TABLESPACE temp

      QUOTA UNLIMITED ON sysaux;

      

      GRANT select any dictionary TO c##rpadv;

      GRANT execute ON dbms_logrep_util TO c##rpadv;

      GRANT select ON system.aq$_queue_tables TO c##rpadv;

      GRANT select ON system.aq$_queues TO c##rpadv;

      GRANT execute ON dbms_lock TO c##rpadv;

      GRANT dba TO c##rpadv;

      

      conn c##rpadv/apv

      

      @?/rdbms/admin/fixed_utlrpadv.sql

      @?/rdbms/admin/prvtrpa.plb

Subprograms

ANALYZE_CURRENT_PERFORMANCE

DISABLE_TRACE

ENABLE_TRACE

ANALYZE_CURRENT_PERFORMANCE

Undocumented utl_rpa_adm.analyze_current_performance( component_name IN VARCHAR2, component_db IN VARCHAR2, compponent_type IN NUMBER);

TBD

DISABLE_TRACE

Undocumented utl_rpa_adm.disable_trace;

exec utl_rpa_adm.disable_trace;

      

      PL/SQL procedure successfully completed.

ENABLE_TRACE

Undocumented utl_rpa_adm.enable_trace;

exec utl_rpa_adm.enable_trace;

      

      PL/SQL procedure successfully completed.