Oracle PRVTEMX_PERF
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Produces  the PL/SQL and SQL required to create a 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 noprivileges 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
DBMS_ADDM
DBMS_REPORT
Packages
PRVTEMX_ADMIN
PRVTEMX_CELL
PRVTEMX_DBHOME
PRVTEMX_MEMORY
What's New In 12cR1
What's New In 12cR2

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