Oracle DBMS

Oracle PRVT_CPADDM Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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