Oracle 12c PRVTEMX

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