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.
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;
Analysis Period
---------------
AWR snapshot range from 25461 to 25462.
Time period starts at 21-JUN-21 08.00.31 AM
Time period ends at 21-JUN-21 08.20.41 AM
Analysis Target
---------------
Database 'TEST21DB' with DB ID 2140826538.
Database version 21.0.0.0.0.
ADDM performed an analysis of instance test21db, numbered 1 and hosted at
PERRITO5.
ADDM detected that the database type is MULTITENANT DB.
Activity During the Analysis Period
-----------------------------------
Total database time was 0 seconds.
The average number of active sessions was 0.
Analysis Period
---------------
AWR snapshot range from 25462 to 25463.
Time period starts at 21-JUN-21 08.20.41 AM
Time period ends at 21-JUN-21 08.40.54 AM
Analysis Target
---------------
Database 'TEST21DB' with DB ID 2140826538.
Database version 21.0.0.0.0.
ADDM performed an analysis of instance test21db, numbered 1 and hosted at
PERRITO5.
ADDM detected that the database type is MULTITENANT DB.
Activity During the Analysis Period
-----------------------------------
Total database time was 0 seconds.
The average number of active sessions was 0.
ADDM Report for Task 'ADDM:2140826538_1_25464'
----------------------------------------------
Analysis Period
---------------
AWR snapshot range from 25463 to 25464.
Time period starts at 21-JUN-21 08.40.54 AM
Time period ends at 21-JUN-21 09.00.57 AM
Analysis Target
---------------
Database 'TEST21DB' with DB ID 2140826538.
Database version 21.0.0.0.0.
ADDM performed an analysis of instance test21db, numbered 1 and hosted at
PERRITO5.
ADDM detected that the database type is MULTITENANT DB.
Activity During the Analysis Period
-----------------------------------
Total database time was 0 seconds.
The average number of active sessions was 0.
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_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;
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 Valid');
END IF;
END;
/
PRINT_ELEMENT
Undocumented
prvt_hdm.print_element(
buffer IN OUT CLOB,
level IN NUMBER,
header IN VARCHAR2,
data IN CLOB,
next_indent IN NUMBER);
TBD
PRINT_LINE
Undocumented
prvt_hdm.print_line(
buffer IN OUT CLOB,
data IN VARCHAR2);
TBD
REGISTER_SLAVE_ACTION
Undocumented
prvt_hdm.register_slave_action(
db_id IN NUMBER,
is_rac_coord IN NUMBER,
end_snap IN NUMBER);
TBD
REPORT
Undocumented
prvt_hdm.report(
taskid IN NUMBER,
level IN NUMBER)
RETURN CLOB;
TBD
RUN
Undocumented
prvt_hdm.run(
db_id IN NUMBER,
inst_id IN NUMBER,
snap1 IN NUMBER,
snap2 IN NUMBER,
task_nm IN VARCHAR2);
TBD
RUN_LOCALS
Undocumented
prvt_hdm.run_locals(task_id IN NUMBER);
exec prvt_hdm.run_locals(3683);
TOP_ADDM_TASKS
Undocumented
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;
TBD
TRANSLATE_CLOB
Undocumented
prvt_hdm.translate_clob(
p_str IN CLOB,
p_from IN VARCHAR2,
p_to IN VARCHAR2)
RETURN CLOB;
TBD
UPDATE_FDG_COUNT
Undocumented
prvt_hdm.update_fdg_count(task_id IN NUMBER);
exec prvt_hdm.update_fdg_count(3683);
VALIDATE_INSTANCE
Undocumented
prvt_hdm.validate_instance(value IN VARCHAR2) RETURN BINARY_INTEGER;