Oracle | PRVTEMX

Oracle PRVTEMX_CELL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Enterprise Manager Express Performance Report

AUTHID CURRENT_USER

Dependencies

DBMS_MANAGEMENT_PACKS	DBMS_SYS_ERROR	SYS_IMXLAGG
DBMS_PERF	DBMS_XMLGEN	V_$DATABASE
DBMS_REPORT	DUAL	WRI$_REPT_CELL
DBMS_SQLTUNE_UTIL2	PRVT_REPORT_TAGS	XMLTYPE
DBMS_SWRF_REPORT_INTERNAL	PRVT_SMGUTIL	XQSEQUENCE

Documented No

First Available 12.1

Security Model Owned by SYS with no privileges granted

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

Subprograms

REPORT_CELL	REPORT_CELL_DIFF_XML	REPORT_CELL_XML
REPORT_CELL_DIFF

REPORT_CELL

Undocumented prvtemx_cell.report_cell( p_is_realtime IN NUMBER, p_start_time IN DATE, p_end_time IN DATE, p_begin_snap IN NUMBER, p_end_snap IN NUMBER, p_dbid IN NUMBER, p_top_n IN NUMBER, p_pct_active IN NUMBER, p_pct_cpu IN NUMBER, p_cell_threshold IN NUMBER, p_disk_threshold IN NUMBER, p_report_level IN VARCHAR2, p_report_type IN VARCHAR2, p_base_path IN VARCHAR2) RETURN CLOB

SELECT prvtemx_cell.report_cell(1);

      

      <html>

       <head>

        <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

        <script language="javascript" type="text/javascript">

         <!--

         var version = "23.0.0.0.0";

         var swf_base_path = "https://download.oracle.com/otn_software/";

      

         document.write('<script language="javascript" type="text/javascript" ' +

         'src="' + swf_base_path + 'emviewers/scripts/activeReportInit.js?' +

         Math.floor((new Date()).getTime()/(7*24*60*60*1000)) + '"></' + 'script>');

         -->

        </script>

       </head>

      <body onload="sendXML();">

       <script type="text/javascript">

        writeIframe();

       </script>

       <script id="fxtmodel" type="text/xml">

        <!--FXTMODEL-->

         <report db_version="23.0.0.0.0" cpu_cores="2" hyperthread="Y" con_id="1"

          con_name="CDB$ROOT" timezone_offset="-18000" packs="2" encode="base64" compress="zlib">

          <report_id>

           <![CDATA[/orarep/cell/main?is_realtime=1]]>

          </report_id>

      eAGzKU8sysvMS1coqSxItVXSNTYwMbFUsitKTcwpycxNVcjNT0lVyMsvUSguLSjILypJTbHRh2qx4wIAiIgVPQ==

         </report>

        <!--FXTMODEL-->

       </script>

      </body>

REPORT_CELL_DIFF

Undocumented prvtemx_cell.report_cell_diff( p_begin_snap1 IN NUMBER, p_end_span1 IN NUMBER, p_dbid1 IN NUMBER, p_begin_snap2 IN NUMBER, p_end_snap2 IN NUMBER, p_dbid2 IN NUMBER, p_top_n IN NUMBER, p_report_level IN VARCHAR2, p_show_sql IN NUMBER, p_base_path IN VARCHAR2, p_report_type IN VARCHAR2) RETURN CLOB;

TBD

REPORT_CELL_DIFF_XML

Undocumented prvtemx_cell. p_begin_snap1 IN NUMBER, p_end_span1 IN NUMBER, p_dbid1 IN NUMBER, p_begin_snap2 IN NUMBER, p_end_snap2 IN NUMBER, p_dbid2 IN NUMBER, p_top_n IN NUMBER, p_report_level IN VARCHAR2, p_show_sql IN NUMBER, p_base_path IN VARCHAR2) RETURN XMLTYPE;

TBD

REPORT_CELL_XML

Undocumented prvtemx_cell.report_cell_xml( p_is_realtime IN NUMBER, p_start_time IN DATE, p_end_time IN DATE, p_begin_snap IN NUMBER, p_end_snap IN NUMBER, p_dbid IN NUMBER, p_top_n IN NUMBER, p_pct_active IN NUMBER, p_pct_cpu IN NUMBER, p_cell_threshold IN NUMBER, p_disk_threshold IN NUMBER, p_report_level IN VARCHAR2, p_report_type IN VARCHAR2, p_base_path IN VARCHAR2) RETURN XMLTYPE;

SELECT prvtemx_cell.report_cell_xml(1);

      

      <report db_version="23.0.0.0.0" cpu_cores="2" hyperthread="Y" con_id="1" con_name="CDB$ROOT" timezone_offset="-28800" packs="2">

       <report_id><![CDATA[/orarep/cell/main?is_realtime=1]]></report_id>

       <warning type="-30449">realtime mode not supported</warning>

      </report>