Oracle | UTL_RPA_ADM_INT

Oracle UTL_RPA_ADM_INT_INVOK 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_LOCK	REPL$_DATABASE	_DBA_REPL_COMPONENT_EVENT
DBMS_LOGREP_UTIL	UTL_RPA_ADM	_DBA_REPL_COMPONENT_LINK
DBMS_STANDARD	UTL_RPA_ADM_INT	_DBA_REPL_COMPONENT_PROP
DBMS_UTILITY	_DBA_REPL_COMPONENT	_DBA_REPL_COMPONENT_STAT
GLOBAL_NAME

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_LOCAL_PERFORMANCE	ANALYZE_PERFORMANCE_INTERNAL	COLLECT_DATA
ANALYZE_PERFORMANCE	ANALYZE_TOPOLOGY

ANALYZE_LOCAL_PERFORMANCE

Undocumented utl_rpa_adm_int_invok.analyze_local_performance( component_name IN VARCHAR2, component_type IN NUMBER);

TBD

ANALYZE_PERFORMANCE

Undocumented utl_rpa_adm_int_invok.analyze_performance( component_name IN VARCHAR2, component_db IN VARCHAR2, component_type IN NUMBER);

TBD

ANALYZE_PERFORMANCE_INTERNAL

Undocumented utl_rpa_adm_int_invok.analyze_performance_internal(commponent_id IN NUMBER);

TBD

ANALYZE_TOPOLOGY

Undocumented utl_rpa_adm_int_invok.analyze_topology(hueristic_pruning IN BOOLEAN);

exec utl_rpa_adm_int_invok.analyze_topology(FALSE);

      

      PL/SQL procedure successfully completed.

COLLECT_DATA

Undocumented

Overload 1 utl_rpa_adm_int_invok.collect_data;

exec utl_rpa_adm_int_invok.collect_data;

      

      PL/SQL procedure successfully completed.

Overload 2 utl_rpa_adm_int_invok.collect_data( bgn_time IN DATE, end_time IN DATE);

exec utl_rpa_adm_int_invok.collect_data(SYSDATE, SYSDATE+1/96);

      

      PL/SQL procedure successfully completed.