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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.