Oracle PRVT_EMX
Version 20c

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 Undocumented

Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.
AUTHID DEFINER
Dependencies
DBA_DIRECTORIES V$DATABASE WRI$_REPT_OPTSTATS
DBMS_ASSERT V_$PARAMETER WRI$_REPT_PERF
DBMS_LOB WRI$_EMX_FILES WRI$_REPT_PLAN_DIFF
DBMS_REPORT WRI$_EMX_FILE_ID_SEQ WRI$_REPT_REPORTS
DBMS_REPORT_LIB WRI$_REPT_ADDM WRI$_REPT_RSRCMGR
DBMS_SQLTUNE WRI$_REPT_ARC WRI$_REPT_RTADDM
DBMS_SQLTUNE_UTIL1 WRI$_REPT_ASH WRI$_REPT_SECURITY
DBMS_STANDARD WRI$_REPT_ASH_OMX WRI$_REPT_SESSION
DBMS_SYSTEM WRI$_REPT_AUTO_INDEX WRI$_REPT_SPMEVOLVE
DBMS_SYS_ERROR WRI$_REPT_AWRV WRI$_REPT_SQLDETAIL
DBMS_UTILITY WRI$_REPT_CELL WRI$_REPT_SQLMONITORI
DUAL WRI$_REPT_CONFIG WRI$_REPT_SQLP
PLITBLM WRI$_REPT_CPADDM WRI$_REPT_SQLT
PRVTEMX_ADMIN WRI$_REPT_DBHOME WRI$_REPT_STATSADV
PRVTEMX_DBHOME WRI$_REPT_DBREPLAY WRI$_REPT_STORAGE
PRVT_ADVISOR WRI$_REPT_EMX_PERF WRI$_REPT_TCB
PRVT_AWR_VIEWER WRI$_REPT_FORMATS WRI$_REPT_XPLAN
PRVT_REPORT_REGISTRY WRI$_REPT_MEMORY  
Documented No
First Available 11.2
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvsexmi.plb
Subprograms
 
APPEND_DIR_SEPARATOR
Appends the operating system appropriate directory separator to a string prvt_emx.append_dir_separator(file_path IN VARCHAR2) RETURN VARCHAR2;
SELECT prvt_emx.append_dir_separator('u01/app/oracle')
FROM dual;

PRVT_EMX.APPEND_DIR_SEPARATOR('u01/app/oracle')
-----------------------------------------
u01/app/oracle/
 
CLEAR_EMEXPRESS_FILES
Undocumented prvt_emx.clear_emexpress_files;
exec prvt_emx.clear_emexpress_files;

PL/SQL procedure successfully completed.
 
CLEAR_FILES
Undocumented prvt_emx.clear_files;
exec prvt_emx.clear_files;

PL/SQL procedure successfully completed.
 
CLEAR_REPORT_FILES
Undocumented prvt_emx.clear_report_files(component_id IN NUMBER);
exec prvt_emx.clear_report_files(2);

PL/SQL procedure successfully completed.
 
EXECUTE_TUNING_TASK_STBY
Undocumented prvt_emx.execute_tuning_task_stby(task_id IN NUMBER);
exec prvt_emx.execute_tuning_task_stby(42);

PL/SQL procedure successfully completed.
 
GENERATE_DBSEARCH_PRED
Undocumented prvt_emx.generate_dbsearch_pred(
p_table IN VARCHAR2,
p_key   IN VARCHAR2,
p_value IN VARCHAR2);
TBD
 
GET_DIRECTORY_PATH
Undocumented prvt_emx.get_directory_path(p_dir_name IN VARCHAR2) RETURN VARCHAR2;
SELECT directory_name
FROM dba_directories
ORDER BY 1;

DIRECTORY_NAME
------------------------------
DATA_PUMP_DIR
JAVA$JOX$CUJS$DIRECTORY$
OPATCH_INST_DIR
OPATCH_LOG_DIR
OPATCH_SCRIPT_DIR
ORACLECLRDIR
ORACLE_BASE
ORACLE_HOME
ORACLE_OCM_CONFIG_DIR
ORACLE_OCM_CONFIG_DIR2
SDO_DIR_ADMIN
SDO_DIR_WORK
XMLDIR
XSDDIR


SELECT prvt_emx.get_directory_path('ORACLE_BASE')
FROM dual;

PRVT_EMX.GET_DIRECTORY_PATH('ORACLE_BASE')
-------------------------------------------
u01/app/oracle
 
GET_EXPANDED_OSD_PATH
Expands any path back to and including root prvt_emx.get_expanded_osd_path(osind_path IN VARCHAR2) RETURN VARCHAR2;
SELECT prvt_emx.get_expanded_osd_path('var/log')
FROM dual;

PRVT_EMX.GET_EXPANDED_OSD_PATH('VAR/LOG')
------------------------------------------
u01/var/log
 
GET_FILE_BINARY
Undocumented prvt_emx.get_file_binary(file_name IN VARCHAR2) RETURN BLOB;
TBD
 
GET_FILE_ID
Undocumented prvt_emx.get_file_id(file_path IN VARCHAR2) RETURN NUMBER;
TBD
 
GET_FILE_NON_BINARY
Undocumented prvt_emx.get_file_non_binary(
FILE_NAME       IN VARCHAR2,
REPLACE_PATTERN IN VARCHAR2,
REPLACE_VALUE   IN VARCHAR2)
RETURN CLOB;
TBD
 
GET_FILE_PROPERTY
Undocumented prvt_emx.get_file_property(file_name IN VARCHAR2) RETURN BINARY_INTEGER;
TBD
 
GET_ORACLE_HOME
Undocumented prvt_emx.get_oracle_home RETURN VARCHAR2;
SELECT prvt_emx.get_oracle_home
FROM dual;

GET_ORACLE_HOME
----------------------------------------
/u01/app/oracle/product/20.0.0/dbhome_1
 
GET_SWF
Undocumented prvt_emx.get_swf(report_reference IN VARCHAR2) RETURN BLOB;
TBD
 
IS_BINARY
Undocumented prvt_emx.is_binary(file_name IN VARCHAR2) RETURN BOOLEAN;
TBD
 
IS_BINARY_WRAPPER
Undocumented prvt_emx.is_binary_wrapper(file_name IN VARCHAR2) RETURN NUMBER;
TBD
 
IS_FILE_PUBLIC
Undocumented prvt_emx.is_file_public(file_name IN VARCHAR2) RETURN NUMBER;
 
 
IS_OMX
Undocumented prvt_emx.is_omx RETURN BOOLEAN;
BEGIN
  IF prvt_emx.is_omx THEN
    dbms_output.put_line('IS OMX');
  ELSE
    dbms_output.put_line('NOT OMX');
  END IF;
END;
/
IS OMX
 
IS_RAC
Undocumented prvt_emx.is_rac RETURN BOOLEAN;
BEGIN
  IF prvt_emx.is_rac THEN
    dbms_output.put_line('IS RAC');
  ELSE
    dbms_output.put_line('NOT RAC');
  END IF;
END;
/
IS RAC
 
REGISTER_COMMON_TAGS
Undocumented prvt_emx.register_common_tags(clear_first IN BOOLEAN);
exec prvt_emx.register_common_tags(FALSE);
*
ERROR at line 1:
ORA-00001: unique constraint (SYS.WRI$_EMX_FILES_IDX_01) violated
ORA-06512: at "SYS.PRVT_EMX", line 367
ORA-06512: at "SYS.PRVT_EMX", line 349
ORA-06512: at "SYS.PRVT_EMX", line 879
ORA-06512: at line 1


exec prvt_emx.register_common_tags(TRUE);

PL/SQL procedure successfully completed.
 
REGISTER_FILES
Undocumented prvt_emx.register_files(
CLEAR_FIRST    IN BOOLEAN,
CACHING_NUMBER IN NUMBER,
UI_MODE        IN VARCHAR2);
see: $ORACLE_HOME/rdbms/admin/execemx.sql
 
REGISTER_REPORTS
Undocumented prvt_emx.register_reports(
CLEAR_FIRST IN BOOLEAN,
UI_MODE     IN VARCHAR2);
TBD
 
VALIDATE_SIZE_CLAUSE
Undocumented prvt_emx.validate_size_clause(p_size_clause IN VARCHAR2) RETURN VARCHAR2;
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
PRVT_REPORT_REGISTRY
What's New In 19c
What's New In 20c

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