Oracle PRVTEMX_CELL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
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