Oracle PRVTEMX_CELL
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Undocumented
AUTHID CURRENT_USER
Dependencies
DBA_HIST_CELL_CONFIG DBMS_SQLTUNE_UTIL2 PRVT_SMGUTIL
DBMS_LOB DBMS_SWRF_REPORT_INTERNAL V$DATABASE
DBMS_MANAGEMENT_PACKS DBMS_SYS_ERROR WRI$_REPT_CELL
DBMS_PERF DUAL XMLTYPE
DBMS_REPORT PRVT_REPORT_TAGS  
Documented No
First Available 12.1.0
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvsemx_cell.plb
Subprograms
 
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 = "12.1.0.2.0";
   var swf_base_path = "http://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="12.1.0.2.0" cpu_cores="2" hyperthread="Y" con_id="1"
    con_name="CDB$ROOT" timezone_offset="-28800" 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="12.1.0.2.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>

Related Topics
Built-in Functions
Built-in Packages
DBMS_REPORT
PRVTEMX_ADMIN
PRVTEMX_DBHOME
PRVTEMX_MEMORY
PRVTEMX_PERF
What's New In 12cR2
What's New In 18cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved