Oracle | PRVTEMX

Oracle PRVTEMX_PERF Version 21c

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 Enterprise Manager Express Performance Report

AUTHID CURRENT_USER

Dependencies

AWR_PDB_ASH_SNAPSHOT	DBMS_SQLTUNE	PRVT_EMX
AWR_ROOT_ASH_SNAPSHOT	DBMS_SQLTUNE_UTIL0	PRVT_REPORT_TAGS
DBMS_ASH_INTERNAL	DBMS_SQLTUNE_UTIL2	V$DATABASE
DBMS_ASSERT	DUAL	V$SESSION
DBMS_AUTO_REPORT	GV$ASH_INFO	WRI$_REPT_SESSION
DBMS_PERF	GV$SESSION	XMLTYPE
DBMS_REPORT	PRVT_ASH_OMX

Documented No

First Available 12.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvsemx_perf.plb

Subprograms

ACTION_CANCEL_SQL_XML

ACTION_KILL_SESSION_XML

REPORT_SESSION_DETAILS_XML

ACTION_CANCEL_SQL_XML (new 21c)

Undocumented prvtemx_perf.action_cancel_sql_xml( p_sid IN NUMBER, p_serial_num IN NUMBER, p_inst_id IN NUMBER, p_sql_id IN VARCHAR2, p_show_sql IN NUMBER) RETURN XMLTYPE;

TBD

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;

      

             SID

      ----------

              17

      

      SELECT serial#

      FROM v$session

      WHERE sid = 17;

      

         SERIAL#

      ----------

           16744

      

      set head off

      set pagesize 0

      set linesize 201

      

      SELECT prvtemx_perf.action_kill_session_xml('TEST', 1, 17, 16744, 1)

      FROM dual;

      

      -- manually formated the output for display:

      PRVTEMX_PERF.ACTION_KILL_SESSION_XML('TEST',1,17,16744,1)

      -----------------------------------------------------------------------------------

      <report db_version="21.0.0.0.0" elapsed_time="0.00" cpu_time="0.00" cpu_cores="2" hyperthread="Y" con_id="1" con_name="CDB$ROOT" timezone_offset="-18000" packs="2">

        <report_id><![CDATA[/orarep/session/kill_session]]></report_id>

        <sql>ALTER SYSTEM KILL SESSION &apos;17,16744,@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