Oracle | UTL_RPA_ADM

Oracle UTL_RPA_ADM_INT 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 DEFINER

Dependencies

DBMS_ASSERT	REPL$_COMPONENT_EVENT_IN	REPL$_DATABASE
DBMS_LOCK	REPL$_COMPONENT_IN	REPL$_PATH_BOTTLENECK_OUT
DBMS_LOGREP_UTIL	REPL$_COMPONENT_LINK	REPL$_PATH_STAT_OUT
DBMS_STANDARD	REPL$_COMPONENT_LINK_IN	UTL_RAW
GV$ACTIVE_SESSION_HISTORY	REPL$_COMPONENT_PROP	UTL_RPA_ADM
GV$INSTANCE	REPL$_COMPONENT_PROP_IN	UTL_RPA_ADM_INT_INVOK
GV$PARAMETER	REPL$_COMPONENT_STAT_IN	_DBA_REPL_COMPONENT_EVENT
REPL$_COMPONENT	REPL$_COMPONENT_STAT_OUT

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

ADD_COMPONENT	DISABLE_TRACE	PREPARE_INPUT
ADD_COMPONENT_EVENT	DISCOVER_STREAM_PATHS	SET_STREAM_FLAGS
ADD_COMPONENT_LINK	DUMP_TRACE	SHIFT_COMPONENT_STATS
ADD_COMPONENT_PROP	ENABLE_TRACE	STORE_COMPONENT_PROPS
ADD_COMPONENT_STAT	GET_ADVISOR_RUN_ID	STORE_DATABASE_INFO
ANALYZE_PERFORMANCE	GET_ADVISOR_RUN_TIME	STORE_REPL_PATHS
ASSIGN_COMPONENT_IDS	GET_LAST_ADVISOR_RUN_TIME	TRACE_COMPONENTS
CLEAN_IN_TABLES	GET_RELEASE_NUMBER	TRACE_COMPONENT_EVENTS
CLEAN_OUT_TABLES	GET_VERSION_NUMBER	TRACE_COMPONENT_LINKS
CLEAN_TABLES	IS_GLOBAL_NAMES	TRACE_COMPONENT_PROPS
COLLECT_COMPONENT_EVENT_LOCAL	IS_STAT_EMPTY	UPDATE_APPLY_PARALLELISM
DELETE_COMPONENT_PROP	IS_TOPOLOGY_CHANGED	UPDATE_DATABASE_INFO
DELETE_DATABASE_INFO

ADD_COMPONENT

Undocumented utl_rpa_adm_int.add_component( canon_component_name IN VARCHAR2, canon_component_db IN VARCHAR2, component_type IN NUMBER, component_property IN NUMBER, component_changed_time IN DATE);

TBD

ADD_COMPONENT_EVENT

Undocumented utl_rpa_adm_int.add_component_event( canon_component_name IN VARCHAR2, canon_component_db IN VARCHAR2, component_type IN NUMBER, sub_component_type IN NUMBER, stat_time IN DATE, session_id IN NUMBER, session_serial# IN NUMBER, event IN VARCHAR2, event_type IN NUMBER, event_count IN NUMBER, total_count IN NUMBER, module_name IN VARCHAR2, action_name IN VARCHAR2, state IN VARCHAR2);

TBD

ADD_COMPONENT_LINK

Undocumented utl_rpa_adm_int.add_component_link( canon_component_name IN VARCHAR2, canon_component_db IN VARCHAR2, source_component_type IN NUMBER, canon_dest_component_name IN VARCHAR2, canon_dest_component_db IN VARCHAR2, desct component_type IN NUMBER);

TBD

ADD_COMPONENT_PROP

Undocumented utl_rpa_adm_int.add_component_prop( canon_component_name IN VARCHAR2, canon_component_db IN VARCHAR2, component_type IN NUMBER, prop_name IN VARCHAR2, prop_value IN VARCHAR2);

TBD

ADD_COMPONENT_STAT

Undocumented utl_rpa_adm_int.add_component_stat( canon_component_name IN VARCHAR2, canon_component_db IN VARCHAR2, component_type IN NUMBER, stat_time IN DATE, count1 IN NUMBER, count2 IN NUMBER, count3 IN NUMBER, latency IN NUMBER, status IN NUMBER, snapshot IN NUMBER);

TBD

ANALYZE_PERFORMANCE

Undocumented utl_rpa_adm_int.analyze_performance( canon_component_name IN VARCHAR2, canon_component_db IN VARCHAR2, component_type IN NUMBER);

TBD

ASSIGN_COMPONENT_IDS

Undocumented utl_rpa_adm_int.assign_component_ids;

exec utl_rpa_adm_int.assign_component_ids;

      

      PL/SQL procedure successfully completed.

CLEAN_IN_TABLES

Undocumented utl_rpa_adm_int.clean_in_tables;

exec utl_rpa_adm_int.clean_in_tables;

      

      PL/SQL procedure successfully completed.

CLEAN_OUT_TABLES

Undocumented utl_rpa_adm_int.clean_out_tables;

exec utl_rpa_adm_int.clean_out_tables;

      

      PL/SQL procedure successfully completed.

CLEAN_TABLES

Undocumented utl_rpa_adm_int.clean_tables(reuse_id IN BOOLEAN);

exec utl_rpa_adm_int.clean_tables(FALSE);

      

      PL/SQL procedure successfully completed.

COLLECT_COMPONENT_EVENT_LOCAL

Undocumented utl_rpa_adm_int.collect_component_event_local( bgn_time IN DATE, end_time IN DATE);

exec utl_rpa_adm_int.collect_component_event_local(SYSDATE, SYSDATE+1/96);

      

      PL/SQL procedure successfully completed.

DELETE_COMPONENT_PROP

Undocumented utl_rpa_adm_int.delete_component_prop;

exec utl_rpa_adm_int.delete_component_prop;

      

      PL/SQL procedure successfully completed.

DELETE_DATABASE_INFO

Undocumented utl_rpa_adm_int.delete_database_info;

exec utl_rpa_adm_int.delete_database_info;

      

      PL/SQL procedure successfully completed.

DISABLE_TRACE

Undocumented utl_rpa_adm_int.disable_trace;

exec utl_rpa_adm_int.disable_trace;

      

      PL/SQL procedure successfully completed.

DISCOVER_STREAM_PATHS

Undocumented utl_rpa_adm_int.discover_stream_paths(start_path_id IN NUMBER);

TBD

DUMP_TRACE

Undocumented utl_rpa_adm_int.dump_trace(message IN VARCHAR2);

exec utl_rpa_adm_int.dump_trace('Test Message');

      

      PL/SQL procedure successfully completed.

ENABLE_TRACE

Undocumented utl_rpa_adm_int.enable_trace;

exec utl_rpa_adm_int.enable_trace;

      

      PL/SQL procedure successfully completed.

GET_ADVISOR_RUN_ID

Undocumented utl_rpa_adm_int.get_advisor_run_id RETURN NUMBER;

SELECT utl_rpa_adm_int.get_advisor_run_id;

      

      GET_ADVISOR_RUN_ID

      ------------------

                       1

GET_ADVISOR_RUN_TIME

Undocumented utl_rpa_adm_int.get_advisor_run_time RETURN DATE

SELECT utl_rpa_adm_int.get_advisor_run_time;

      

      GET_ADVISOR_RUN_TIME

      --------------------

      30-JUL-2025 08:26:26

GET_LAST_ADVISOR_RUN_TIME

Undocumented utl_rpa_adm_int.get_last_advisor_run_time RETURN DATE

SELECT utl_rpa_adm_int.get_last_advisor_run_time;

      

      GET_LAST_ADVISOR_RUN

      --------------------

      30-AUG-2025 08:21:26

GET_RELEASE_NUMBER

Undocumented utl_rpa_adm_int.get_release_number(version IN VARCHAR2) RETURN NUMBER;

SELECT utl_rpa_adm_int.get_release_number('23.8.0.0');

      

      UTL_RPA_ADM_INT.GET_RELEASE_NUMBER('23.8.0.0')

      ----------------------------------------------

                                                
      2308

GET_VERSION_NUMBER

Undocumented utl_rpa_adm_int.get_version_number(version IN VARCHAR2) RETURN BINARY_INTEGER;

SELECT utl_rpa_adm_int.get_version_number('23.8.0.0');

      

      UTL_RPA_ADM_INT.GET_VERSION_NUMBER('23.8.0.0')

      ----------------------------------------------

                                            23080000

IS_GLOBAL_NAMES

Undocumented utl_rpa_adm_int.is_global_names RETURN BOOLEAN;

BEGIN

        IF utl_rpa_adm_int.is_global_names THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

IS_STAT_EMPTY

Undocumented utl_rpa_adm_int.is_stat_empty RETURN OOLEAN;

BEGIN

        IF utl_rpa_adm_int.is_stat_empty THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

IS_TOPOLOGY_CHANGED

Undocumented utl_rpa_adm_int.is_topoogy_changed RETURN BOOLEAN;

BEGIN

        IF utl_rpa_adm_int.is_topology_changed THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

PREPARE_INPUT

Undocumented utl_rpa_adm_int.prepare_input;

exec utl_rpa_adm_int.prepare_input;

      

      PL/SQL procedure successfully completed.

SET_STREAM_FLAGS

Undocumented utl_rpa_adm_int.set_stream_flags;

exec utl_rpa_adm_int.set_stream_flags;

      

      PL/SQL procedure successfully completed.

SHIFT_COMPONENT_STATS

Undocumented utl_rpa_adm_int.shift_component_stats;

exec utl_rpa_adm_int.shift_component_stats;

      

      PL/SQL procedure successfully completed.

STORE_COMPONENT_PROPS

Undocumented utl_rpa_adm_int.store_component_props;

exec utl_rpa_adm_int.store_component_props;

      

      PL/SQL procedure successfully completed.

STORE_DATABASE_INFO

Undocumented utl_rpa_adm_int.store_database_info;

exec utl_rpa_adm_int.store_database_info;

      

      PL/SQL procedure successfully completed.

STORE_REPL_PATHS

Undocumented utl_rpa_adm_int.store_repl_paths;

exec utl_rpa_adm_int.store_repl_paths;

      

      PL/SQL procedure successfully completed.

TRACE_COMPONENTS

Undocumented utl_rpa_adm_int.trace_components( flag IN RAW, flag_mesg IN VARCHAR2);

TBD

TRACE_COMPONENT_EVENTS

Undocumented utl_rpa_adm_int.trace_component_events(comp_type IN NUMBER);

TBD

TRACE_COMPONENT_LINKS

Undocumented utl_rpa_adm_int.trace_component_links( flag IN RAW, flag_mesg IN VARCHAR2);

TBD

TRACE_COMPONENT_PROPS

Undocumented utl_rpa_adm_int.trace_component_props(prop_name IN VARCHAR2);

TBD

UPDATE_APPLY_PARALLELISM

Undocumented utl_rpa_adm_int.update_apply_parallelism;

exec utl_rpa_adm_int.update_apply_parallelism;

      

      PL/SQL procedure successfully completed.

UPDATE_DATABASE_INFO

Undocumented utl_rpa_adm_int.update_database_info(canon_global_name IN VARCHAR2);

TBD