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 (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

Related Topics
Built-in Functions
Built-in Packages
DBMS_ASH
DBMS_ASH_INTERNAL
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx