Oracle | PRVT

Oracle PRVT_CPADDM Version 21c

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 Undocumented

AUTHID CURRENT_USER

Dependencies

DBA_WORKLOAD_REPLAYS	PRVT_AWR_EVTLIST	PRVT_REPORT_TAGS
DUAL	PRVT_AWR_NUMTAB	WRI$_REPT_CPADDM
PLITBLM	PRVT_AWR_PERIOD	XMLSEQUENCE
PRVT_AWR_DATA	PRVT_AWR_XMLTAB	XMLTYPE
PRVT_AWR_DATA_CP

Documented No

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvscpaddm.plb

Subprograms

COMPARE_CAPTURE_REPLAY	COMPARE_REPLAY_REPLAY	GET_SNAPSHOTS
COMPARE_DATABASES	COMPARE_WCR_REPORT_XML	ONE_TIME_PERIOD
COMPARE_INSTANCES	CPADDM_REPORT_XML

COMPARE_CAPTURE_REPLAY

Undocumented prvt_cpaddm.compare_capture_replay( p_replay_id IN NUMBER, p_report_reference IN VARCHAR2);

TBD

COMPARE_DATABASES

Undocumented prvt_cpaddm.compare_databases( p_base_dbid IN NUMBER, p_base_begin_snap_id IN NUMBER, p_base_end_snap_id IN NUMBER, p_comp_dbid IN NUMBER, p_comp_begin_snap_id IN NUMBER, p_comp_end_snap_id IN NUMBER, p_report_reference IN VARCHAR2);

TBD

COMPARE_INSTANCES

Undocumented prvt_cpaddm.compare_instances( p_base_dbid IN NUMBER, p_base_begin_snap_id IN NUMBER, p_base_end_snap_id IN NUMBER, p_base_instance_number IN NUMBER, p_comp_dbid IN NUMBER, p_comp_begin_snap_id IN NUMBER, p_comp_end_snap_id IN NUMBER, p_comp_instance_number IN NUMBER, p_report_reference IN VARCHAR2);

TBD

COMPARE_REPLAY_REPLAY

Undocumented prvt_cpaddm.compare_replay_replay( p_base_replay_id IN NUMBER, p_comp_replay_id IN NUMBER, p_report_reference IN VARCHAR2);

TBD

COMPARE_WCR_REPORT_XML

Undocumented prvt_cpaddm.compare_wcr_report_xml( p_replay_id1 IN NUMBER, p_replay_id2 IN NUMBER, p_report_reference IN VARCHAR2);

TBD

CPADDM_REPORT_XML

Undocumented prvt_cpaddm.cpaddm_report_xml( p_bdbid IN NUMBER, p_binstid IN NUMBER, p_bbeginsnap IN NUMBER, p_bendsnap IN NUMBER, p_cdbid IN NUMBER, p_cinstid IN NUMBER, p_Cbeginsnap IN NUMBER, p_cendsnap IN NUMBER, p_report_reference IN VARCHAR2);

TBD

GET_SNAPSHOTS

Undocumented prvt_cpaddm.get_snapshots( p_dbid IN NUMBER, p_instid IN NUMBER, p_begin_time IN DATE, p_end_time IN DATE, p_begin_snap IN OUT NUMBER, p_end_snap IN OUT NUMBER);

TBD

ONE_TIME_PERIOD

Undocumented prvt_cpaddm.one_time_period( p_name IN VARCHAR2, p_dbid IN NUMBER, p_begin_snap_id IN NUMBER, p_end_snap_id IN NUMBER, p_instance_number IN NUMBER);

TBD