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;