Oracle PRVT_ASH_OMX
Version 19.3

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 DBMS_REPORT WRI$_REPT_ASH_OMX
DBMS_PERF PRVT_REPORT_TAGS XMLTYPE
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 (new 19c)
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 (new 19c)
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_ASH
DBMS_ASH_INTERNAL
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx