Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose
Utilities for creating ADDM Reports
AUTHID
DEFINER
Data Types
TYPE addm_cont_db_tb
TYPE addm_cont_inst_tb
Dependencies
SELECT name FROM dba_dependencies WHERE referenced_name = 'PRVT_HDM' UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'PRVT_HDM' ORDER BY 1;
Returns 113 objects
Documented
No
Exceptions
Error Code
Reason
ORa-13605
The specified task or object 65377 does not exist for the current user.
prvt_hdm.addm_reports(
p_dbid IN NUMBER,
p_begin_snap_id IN NUMBER,
p_end_snap_id IN NUMBER,
p_instance_number IN NUMBER,
p_html IN NUMBER)
RETURN sys.awrrpt_html_type_table;
SELECT * FROM TABLE(prvt_hdm.addm_reports(1472724728, 1545, 1547, 1, 1));
OUTPUT
----------------------------------------------------------------------------------------
ADDM Report for Task 'UW_TASK1'
-------------------------------
Analysis Period
---------------
AWR snapshot range from 1545 to 1547.
Time period starts at 16-JUL-25 05.58.28 PM
Time period ends at 16-JUL-25 07.58.50 PM
Analysis Target
---------------
Database 'FREE' with DB ID 1472724728.
Database version 23.0.0.0.0.
ADDM performed an analysis of instance free, numbered 1 and hosted at DDMORGAN-DQQ9KR.
ADDM detected that the database type is MULTITENANT DB.
Activity During the Analysis Period
-----------------------------------
Total database time was 47 seconds.
The average number of active sessions was .01.
prvt_hdm.addm_report_json(
p_dbid IN VARCHAR2,
p_inst_id IN VARCHAR2,
p_begin_time IN VARCHAR2,
p_end_time IN VARCHAR2,
p_days IN VARCHAR2,
p_owner IN VARCHAR2,
p_task_name IN VARCHAR2,
p_section IN VARCHAR2)
RETURN CLOB;
prvt_hdm.addm_report_xml(
p_dbid IN VARCHAR2,
p_inst_id IN VARCHAR2,
p_begin_time IN VARCHAR2,
p_end_time IN VARCHAR2,
p_days IN VARCHAR2,
p_owner IN VARCHAR2,
p_task_name IN VARCHAR2,
p_section IN VARCHAR2,
p_spotrep IN VARCHAR2,
p_spotlist IN VARCHAR2,
p_show_sql IN VARCHAR2)
RETURN XMLTYPE;
prvt_hdm.addm_task_list_json(
p_dbid IN VARCHAR2,
p_inst_id IN VARCHAR2,
p_begin_time IN VARCHAR2,
p_end_time IN VARCHAR2,
p_owner IN VARCHAR2)
RETURN CLOB;
prvt_hdm.addm_task_list_xml(
p_dbid IN NUMBER,
p_inst_id IN NUMBER,
p_begin_time IN DATE,
p_end_time IN DATE,
p_owner IN VARCHAR2,
p_show_sql IN BOOLEAN)
RETURN XMLTYPE;
prvt_hdm.exec_predef_call_switch_cont_callout(
dest_con_id IN BINARY_INTEGER,
call_id IN BINARY_INTEGER,
num_arg1 IN BINARY_INTEGER,
num_arg2 IN BINARY_INTEGER,
num_arg3 IN BINARY_INTEGER,
num_arg4 IN BINARY_INTEGER,
num_arg5 IN BINARY_INTEGER,
num_arg6 IN BINARY_INTEGER,
num_arg7 IN BINARY_INTEGER,
num_arg8 IN BINARY_INTEGER,
txt_arg1 IN VARCHAR2,
txt_arg1_len IN BINARY_INTEGER,
txt_arg2 IN VARCHAR2,
txt_arg2_len IN BINARY_INTEGER)
Returns TRUE if the parameter name corresponds to a valid parameter
prvt_hdm.parameter_exists(parameter_name IN VARCHAR2) RETURN BOOLEAN;
BEGIN
IF prvt_hdm.parameter_exists('NotValid') THEN
dbms_output.put_line('NotValid Is A Valid Parameter');
ELSE
dbms_output.put_line('NotValid Is Not A Valid
Parameter');
END IF;
END;
/ NotValid Is Not Valid A Valid Parameter
prvt_hdm.top_addm_tasks(
p_dbib IN NUMBER,
p_begin_snap_id IN NUMBER,
p_end_snap_id IN NUMBER,
p_instance_number IN NUMBER)
RETURN sys.awrrpt_html_type_table;
