Oracle | PRVT_ASH

Oracle PRVT_ASH_OMX 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 Active Session History for Oracle Netsuite Order Management (OMX)

AUTHID CURRENT_USER

Dependencies

DBMS_ASH	PRVTEMX_PERF	WRI$_REPT_ASH_OMX
DBMS_PERF	PRVT_REPORT_TAGS	XMLTYPE
DBMS_REPORT

Documented No

First Available 19c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvsash.plb

Subprograms

REPORT_OMX_ASHVIEWER_XML

REPORT_OMX_TIMEPICKER_XML

REPORT_OMX_ASHVIEWER_XML

Generates XML ASH Viewer Report prvt_ash_omx.report_omx_ashviewer_xml( dbid IN NUMBER, inst_id IN NUMBER, time_mode IN VARCHAR2, begin_time_utc IN VARCHAR2, end_time_utc IN VARCHAR2, time_since_sec IN NUMBER, bucket_size IN NUMBER, minimize_cost IN VARCHAR2, include_bg IN VARCHAR2, verboxe_xml IN VARCHAR2, show_sql IN VARCHAR2, filtered IN NUMBER, filter_list IN VARCHAR2, report_params IN sys.dbms_report.ref_string_idspec) RETURN XMLTYPE;

TBD

REPORT_OMX_TIMEPICKER_XML

Generates XML ASH Time Picker Report prvt_ash_omx.report_omx_timepicker_xml( dbid IN NUMBER, inst_id IN NUMBER, time_mode IN VARCHAR2, begin_time_utc IN VARCHAR2, end_time_utc IN VARCHAR2, time_since_sec IN NUMBER, bucket_size IN NUMBER, include_bg IN VARCHAR2, verbose_xml IN VARCHAR2, show_sql IN VARCHAR2, filtered IN NUMBER, filter_list IN VARCHAR2, report_params IN sys.dbms_report.ref_string_idspec) RETURN XMLTYPE;

TBD