Oracle | PRVTEMX

Oracle PRVTEMX_PERF Version 21c

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

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