Oracle PRVTEMX_MEMORY
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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)
FROM dual;

spool off
spool /home/oracle/typical_test.xml

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

spool off
spool /home/oracle/all_test.xml

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

spool off

Related Topics
Built-in Functions
Built-in Packages
DBMS_REPORT
PRVTEMX_ADMIN
PRVTEMX_CELL
PRVTEMX_DBHOME
PRVTEMX_PERF
What's New In 18c
What's New In 19c

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