Oracle | PRVT_ASH

Oracle PRVT_ASH_OMX Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Active Session History for Oracle Netsuite Order Management (OMX)

AUTHID CURRENT_USER

Dependencies

AWR_PDB_SNAPSHOT	DBMS_REPORT	PRVT_REPORT_TAGS
DBMS_ASH	DBMS_SQLTUNE_UTIL2	WRI$_REPT_ASH_OMX
DBMS_PERF	PRVTEMX_PERF	XMLTYPE

Documented No

First Available 19c

Security Model Owned by SYS with no privileges granted

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

Subprograms

FIND_ASH_TIMEZONE

REPORT_OMX_ASHVIEWER_XML

REPORT_OMX_TIMEPICKER_XML

FIND_ASH_TIMEZONE (new 23ai)

Undocumented prvt_ash_omx.find_ash_timezone( l_dbid IN NUMBER, l_inst_id IN NUMBER, l_end_time IN DATE) RETURN VARCHAR2;

SELECT dbid FROM v$database;

      

            DBID

      ----------

      1405253007

      

      col ashtz format a8

      

      SELECT prvt_ash_omx.find_ash_timezone(1405253007, 1, SYSDATE) AS ASHTZ;

      

      ASHTZ

      --------

      0:0

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