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
The build script states DBMS_PERF stands for "DBMS Performance Reports." The output of these functions is not directly human readable but rather intended for Oracle's new Enterprise Manager Express.
Generates a composite active performance report of the entire database system for a specified time period
dbms_perf.report_perfhub_xml(
is_realtime IN NUMBER DEFAULT NULL,
outer_start_time IN DATE DEFAULT NULL,
outer_end_time IN DATE DEFAULT NULL,
selected_start_time IN DATE DEFAULT NULL,
selected_end_time IN DATE DEFAULT NULL,
inst_id IN NUMBER DEFAULT NULL,
dbid IN NUMBER DEFAULT NULL,
monitor_list_detail IN NUMBER DEFAULT NULL,
workload_sql_detail IN NUMBER DEFAULT NULL,
addm_task_detail IN NUMBER DEFAULT NULL,
report_reference IN VARCHAR2 DEFAULT NULL,
report_level IN VARCHAR2 DEFAULT NULL,
type IN VARCHAR2 DEFAULT 'ACTIVE',
base_path IN VARCHAR2 DEFAULT NULL)
RETURN CLOB;
Generates a composite active performance report of the entire database system for a specified time period in XML format
dbms_perf.report_perfhub_xml(
is_realtime IN NUMBER DEFAULT NULL,
outer_start_time IN DATE DEFAULT NULL,
outer_end_time IN DATE DEFAULT NULL,
selected_start_time IN DATE DEFAULT NULL,
selected_end_time IN DATE DEFAULT NULL,
inst_id IN NUMBER DEFAULT NULL,
dbid IN NUMBER DEFAULT NULL,
monitor_list_detail IN NUMBER DEFAULT NULL,
workload_sql_detail IN NUMBER DEFAULT NULL,
addm_task_detail IN NUMBER DEFAULT NULL,
compress_xml IN BINARY_INTEGER DEFAULT NULL,
report_reference IN VARCHAR2 DEFAULT NULL,
report_level IN VARCHAR2 DEFAULT NULL,
base_path IN VARCHAR2 DEFAULT NULL)
RETURN XMLTYPE;
Retrieves Session Details for all tabs for generating active report
dbms_perf.report_session(
inst_id IN NUMBER DEFAULT NULL,
sid IN NUMBER DEFAULT NULL,
serial IN NUMBER DEFAULT NULL,
is_realtime IN NUMBER DEFAULT NULL,
outer_start_time IN DATE DEFAULT NULL,
outer_end_time IN DATE DEFAULT NULL,
selected_start_time IN DATE DEFAULT NULL,
selected_end_time IN DATE DEFAULT NULL,
dbid IN NUMBER DEFAULT NULL,
monitor_list_detail IN NUMBER DEFAULT NULL,
report_reference IN VARCHAR2 DEFAULT NULL,
report_level IN VARCHAR2 DEFAULT NULL,
type IN VARCHAR2 DEFAULT 'ACTIVE',
base_path IN VARCHAR2 DEFAULT NULL)
RETURN CLOB;
Retrieves Session Details XML for all tabs for generating active report
dbms_perf.report_session_xml(
inst_id IN NUMBER DEFAULT NULL,
sid IN NUMBER DEFAULT NULL,
serial IN NUMBER DEFAULT NULL,
is_realtime IN NUMBER DEFAULT NULL,
outer_start_time IN DATE DEFAULT NULL,
outer_end_time IN DATE DEFAULT NULL,
selected_start_time IN DATE DEFAULT NULL,
selected_end_time IN DATE DEFAULT NULL,
dbid IN NUMBER DEFAULT NULL,
monitor_list_detail IN NUMBER DEFAULT NULL,
compress_xml IN BINARY_INTEGER DEFAULT NULL,
report_reference IN VARCHAR2 DEFAULT NULL,
report_level IN VARCHAR2 DEFAULT NULL,
base_path IN VARCHAR2 DEFAULT NULL)
RETURN XMLTYPE;
Retrieves SQL Details text for all tabs for generating active report
report_sql(
sql_id IN VARCHAR2 DEFAULT NULL,
is_realtime IN NUMBER DEFAULT NULL,
outer_start_time IN DATE DEFAULT NULL,
outer_end_time IN DATE DEFAULT NULL,
selected_start_time IN DATE DEFAULT NULL,
selected_end_time IN DATE DEFAULT NULL,
inst_id IN NUMBER DEFAULT NULL,
dbid IN NUMBER DEFAULT NULL,
monitor_list_detail IN NUMBER DEFAULT NULL,
report_reference IN VARCHAR2 DEFAULT NULL,
report_level IN VARCHAR2 DEFAULT NULL,
type IN VARCHAR2 DEFAULT 'ACTIVE',
base_path IN VARCHAR2 DEFAULT NULL)
RETURN CLOB;
Retrieves SQL Details XML for all tabs for generating active report
dbms_perf.report_sql_xml(
sql_id IN VARCHAR2 DEFAULT NULL,
is_realtime IN NUMBER DEFAULT NULL,
outer_start_time IN DATE DEFAULT NULL,
outer_end_time IN DATE DEFAULT NULL,
selected_start_time IN DATE DEFAULT NULL,
selected_end_time IN DATE DEFAULT NULL,
inst_id IN NUMBER DEFAULT NULL,
dbid IN NUMBER DEFAULT NULL,
monitor_list_detail IN NUMBER DEFAULT NULL,
compress_xml IN BINARY_INTEGER DEFAULT NULL,
report_reference IN VARCHAR2 DEFAULT NULL,
report_level IN VARCHAR2 DEFAULT NULL,
base_path IN VARCHAR2 DEFAULT NULL)
RETURN XMLTYPE;