Oracle PRVTEMX_CELL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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 (new 12.2)
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 (new 12.2)
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
DBMS_REPORT
Packages
PRVTEMX_ADMIN
PRVTEMX_DBHOME
PRVTEMX_MEMORY
PRVTEMX_PERF
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved