Oracle | PRVTEMX

Oracle PRVTEMX_CELL 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

DBMS_MANAGEMENT_PACKS	DBMS_SWRF_REPORT_INTERNAL	PRVT_SMGUTIL
DBMS_PERF	DBMS_SYS_ERROR	V$DATABASE
DBMS_REPORT	DUAL	WRI$_REPT_CELL
DBMS_SQLTUNE_UTIL2	PRVT_REPORT_TAGS	XMLTYPE

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)

      FROM dual;

      

      <html>

       <head>

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

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

         <!--

         var version = "21.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="21.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)

      FROM dual;

      

      <report db_version="21.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>