Oracle | UTL_RPA_ADM

Oracle UTL_RPA_ADM_INT Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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-2023 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-JUL-2023 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.2.0.0');

      

      UTL_RPA_ADM_INT.GET_RELEASE_NUMBER('23.2.0.0')

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

                                                2302

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.2.0.0');

      

      UTL_RPA_ADM_INT.GET_VERSION_NUMBER('23.2.0.0')

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

                                            23020000

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