Oracle | UTL_RPA

Oracle UTL_RPA_ADM Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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.