Oracle | PRVTEMX

Oracle PRVTEMX_MEMORY Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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

Security Model Owned by SYS with no privileges 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/basic_test.xml

      

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

      

      spool off

      -- 337 lines of XML output

      

      spool /home/oracle/typical_test.xml

      

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

      

      spool off

      -- 949 lines of XML output

      

      spool /home/oracle/all_test.xml

      

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

      

      spool off

      -- 949 lines of XML output