Oracle PRVTEMX_PERF
Version 18.3.0.1

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 Enterprise Manager Express Performance Report
AUTHID CURRENT_USER
Dependencies
DBA_HIST_ASH_SNAPSHOT DBMS_SQLTUNE PRVT_REPORT_TAGS
DBMS_ASH_INTERNAL DBMS_SQLTUNE_UTIL0 V$DATABASE
DBMS_AUTO_REPORT DUAL V$SESSION
DBMS_PERF GV$ASH_INFO WRI$_REPT_SESSION
DBMS_REPORT GV$SESSION XMLTYPE
Documented No
First Available 12.1.0.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvsemx_perf.plb
 
ACTION_KILL_SESSION_XML
Produces in XML format the report information and DCL to kill a connected session prvtemx_perf.action_kill_session_xml(
report_reference IN VARCHAR2,
p_isnt_id        IN NUMBER,
p_sid            IN NUMBER,
p_serial_num     IN NUMBER,
p_show_sql       IN NUMBER)
RETURN XMLTYPE;
conn / as sysdba

SELECT sid
FROM v$mystat
WHERE rownum = 1
;

SELECT serial#
FROM v$session
WHERE sid =
16;

set head off
set pagesize 0
set linesize 201

SELECT prvtemx_perf.action_kill_session_xml('TEST', 1, 16, 17585, 1)
FROM dual;

-- manually formated the output for display:
<report db_version="12.1.0.1.0" cpu_cores="2" hyperthread="Y" con_id="1" con_name="CDB$ROOT" timezone_offset="-25200" elapsed_time="0.00" cpu _time="0.00" packs="2">
  <report_id><![CDATA[/orarep/session/kill_session]]></report_id>
  <sql>ALTER SYSTEM KILL SESSION &apos;16,17585,@1&apos; immediate</sql>
</report>
 
REPORT_SESSION_DETAILS_XML
Undocumented prvtemx_perf.report_session_details_xml(
report_reference      IN VARCHAR2,
p_sid                 IN NUMBER,
p_isnt_id             IN NUMBER,
p_serial_num          IN NUMBER,
p_activity_dimension  IN VARCHAR2,
p_is_realtime         IN NUMBER,
p_starttime           IN DATE,
p_endtime             IN DATE,
p_monitor_list_detail IN NUMBER,
p_show_sql            IN NUMBER)
RETURN XMLTYPE;
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_ADDM
DBMS_REPORT
PRVTEMX_ADMIN
PRVTEMX_CELL
PRVTEMX_DBHOME
PRVTEMX_MEMORY
What's New In 18cR3
What's New In 19cR3

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