Oracle PRVTEMX_MEMORY
Version 12.1.0.2

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 Produces the PL/SQL and SQL required to create a memory report.
AUTHID CURRENT_USER
Dependencies
DBMS_REPORT PRVT_AWR_VIEWER V$SYSTEM_PARAMETER
DBMS_SYS_ERROR PRVT_REPORT_TAGS WRI$_REPT_MEMORY
DUAL V$OSSTAT XMLTYPE
Documented No
First Available 12.1.0.1
Security Model Owned by SYS with noprivileges granted
Source {ORACLE_HOME}/rdbms/admin/prvsemx_memory.plb
 
REPORT_MEMORY_XML
Returns, in XML format, PL/SQL and SQL for obtaining a memory report prvtemx_memory.report_memory_xml(
p_level      IN VARCHAR2,
p_inst_id    IN NUMBER,
p_top_n      IN NUMBER,
p_show_sql   IN NUMBER,
p_reptab     IN NUMBER,
p_start_time IN DATE,
p_end_time   IN DATE)
RETURN XMLTYPE;
conn / as sysdba

set trimspool on
set head off
set pagesize 0
set linesize 201
spool /home/oracle/testing.xml

SELECT prvtemx_memory.report_memory_xml('BASIC', 1, 5, 1, 1, SYSDATE-1, SYSDATE)
FROM dual;

SELECT prvtemx_memory.report_memory_xml('TYPICAL', 1, 5, 1, 1, SYSDATE-1, SYSDATE)
FROM dual;

SELECT prvtemx_memory.report_memory_xml('ALL', 1, 5, 1, 1, SYSDATE-1, SYSDATE)
FROM dual;

-- manually parsing the XML and running the statements produces the following output which has been formated for display:
<memory memmgmt="asmm" inst_cnt="1">
  <comp name="Memory Management">manual</comp>
  <comp name="SGA Memory Management">auto</comp>
  <comp name="PGA Memory Management">auto</comp>
  <comp name="sga_target" class="sga">2400</comp>
  <comp name="pga_aggregate_limit" class="pga">2048</comp>
  <comp name="pga_aggregate_target" class="pga">800</comp>
</memory>

Related Topics
DBMS_REPORT
Packages
PRVTEMX_ADMIN
PRVTEMX_CELL
PRVTEMX_DBHOME
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