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 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_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.