| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Undocumented |
| AUTHID |
DEFINER |
| Dependencies |
| DBA_DIRECTORIES |
WRI$_EMX_FILES |
WRI$_REPT_MEMORY |
| DBMS_ASSERT |
WRI$_EMX_FILE_ID_SEQ |
WRI$_REPT_OPTSTATS |
| DBMS_LOB |
WRI$_REPT_ADDM |
WRI$_REPT_PERF |
| DBMS_REPORT |
WRI$_REPT_ARC |
WRI$_REPT_PLAN_DIFF |
| DBMS_REPORT_LIB |
WRI$_REPT_ASH |
WRI$_REPT_REPORTS |
| DBMS_SQLTUNE |
WRI$_REPT_ASH_OMX |
WRI$_REPT_RSRCMGR |
| DBMS_SQLTUNE_UTIL1 |
WRI#_REPT_AUTOIM |
WRI$_REPT_RTADDM |
| DBMS_STANDARD |
WRI$_REPT_AUTO_CLUSTERING |
WRI$_REPT_SECURITY |
| DBMS_SYSTEM |
WRI$_REPT_AUTO_INDEX |
WRI$_REPT_SESSION |
| DBMS_SYS_ERROR |
WRI$_REPT_AUTO_MV |
WRI$_REPT_SPMEVOLVE |
| DBMS_UTILITY |
WRI$_REPT_AUTO_ZONEMAP |
WRI$_REPT_SQLDETAIL |
| DUAL |
WRI$_REPT_AWRV |
WRI$_REPT_SQLHISTORY |
| PLITBLM |
WRI$_REPT_CELL |
WRI$_REPT_SQLMONITOR |
| PRVTEMX_ADMIN |
WRI$_REPT_CONFIG |
WRI$_REPT_SQLPI |
| PRVTEMX_DBHOMEPRVTEMX_PERF |
WRI$_REPT_CPADDM |
WRI$_REPT_SQLT |
| PRVT_ADVISOR |
WRI$_REPT_DBHOME |
WRI$_REPT_STATSADV |
| PRVT_AWR_VIEWER |
WRI$_REPT_DBREPLAY |
WRI$_REPT_STORAGE |
| PRVT_REPORT_REGISTRY |
WRI$_REPT_EMX_PERF |
WRI$_REPT_TCB |
| V$DATABASE |
WRI$_REPT_FORMATS |
WRI$_REPT_XPLAN |
| V_$PARAMETER |
|
|
|
| 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');
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
DBMS_OPTIM_ADMINDIR
DBMS_OPTIM_LOGDIR
JAVA$JOX$CUJS$DIRECTORY$
OPATCH_INST_DIR
OPATCH_LOG_DIR
OPATCH_SCRIPT_DIR
ORACLE_BASE
ORACLE_HOME
SDO_DIR_ADMIN
XMLDIR
XSDDIR
SELECT prvt_emx.get_directory_path('ORACLE_BASE');
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');
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;
GET_ORACLE_HOME
----------------------------------------
/u01/app/oracle/product/23.0.0/dbhome_1 |
| |
| 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; |
| TBD |
| |
| 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 |
| 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);
*
ORA-00001: unique constraint (SYS.WRI$_EMX_FILES_IDX_01) violated
exec prvt_emx.register_common_tags(TRUE);
PL/SQL procedure successfully completed. |
| |
REGISTER_EMXONLY_REPORTS (new 23ai)  |
| Undocumented |
prvt_emx.register_emxonly_reports; |
exec prvt_emx.register_emxonly_reports;
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 |
| |
| REGISTER_UI (new 23ai) |
| Undocumented |
prvt_emx.register_ui(
clear_first IN BOOLEAN,
caching_number IN NUMBER,
ui_mode IN VARCHAR2); |
| TBD |
| |
| VALIDATE_SIZE_CLAUSE |
| Undocumented |
prvt_emx.validate_size_clause(p_size_clause IN VARCHAR2) RETURN VARCHAR2; |
| TBD |