Oracle | PRVT_ASH

Oracle PRVT_ASH_OMX Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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