Oracle | PRVT_ASH

Oracle PRVT_ASH_OMX Version 23c

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

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 23c)

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