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
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 or 12.1
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
OMX_LOCALES (new 21c)
Returns an array of unknown structure of OMX locales
prvt_emx.omx_locales RETURN sys.prvt_emx.locales_array;
TBD
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