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 will be available on generic Linux platforms in January and soon on AIX and Windows

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