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
Provides an interface to view SQL Monitoring and Real-time Automatic Database Diagnostic Monitor (ADDM) data that has been captured into Automatic Workload Repository (AWR).
It also provides subprograms to control the behavior of how these data are captured to AWR.
Obtains the stored XML report for a given report ID
dbms_auto_report.report_repository_detail(
rid IN NUMBER DEFAULT NULL,
type IN VARCHAR2 DEFAULT 'XML',
base_path IN VARCHAR2 DEFAULT NULL)
RETURN CLOB;
SELECT dbms_auto_report.report_repository_list_xml(SYSDATE-1)
FROM dual;
SELECT dbms_auto_report.report_repository_detail(569)
FROM dual;
Obtains an XML report of the list of SQL Monitor and Real-time ADDM data captured in AWR
dbms_auto_report.report_repository_list_xml(
active_since IN DATE DEFAULT NULL,
active_upto IN DATE DEFAULT NULL,
snapshot_id IN NUMBER DEFAULT NULL,
dbid IN NUMBER DEFAULT NULL,
inst_id IN NUMBER DEFAULT NULL,
con_dbid IN NUMBER DEFAULT NULL,
session_id IN NUMBER DEFAULT NULL,
session_serial IN NUMBER DEFAULT NULL,
component_name IN VARCHAR2 DEFAULT NULL,
key1 IN VARCHAR2 DEFAULT NULL,
key2 IN VARCHAR2 DEFAULT NULL,
key3 IN VARCHAR2 DEFAULT NULL,
report_level IN VARCHAR2 DEFAULT 'TYPICAL',
base_path IN VARCHAR2 DEFAULT NULL,
top_n_count IN NUMBER DEFAULT NULL,
top_n_rankby IN VARCHAR2 DEFAULT 'db_time',
top_n_detail_count IN NUMBER)
RETURN XMLTYPE;