Oracle | PRVT

Oracle PRVT_EMX Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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	GET_FILE_BINARY	IS_FILE_PUBLIC
CLEAR_EMEXPRESS_FILES	GET_FILE_ID	IS_OMX
CLEAR_FILES	GET_FILE_NON_BINARY	IS_RAC
CLEAR_REPORT_FILES	GET_FILE_PROPERTY	OMX_LOCALESM
EXECUTE_TUNING_TASK_STBY	GET_ORACLE_HOME	REGISTER_COMMON_TAGS
GENERATE_DBSEARCH_PRED	GET_SWF	REGISTER_FILES
GET_DIRECTORY_PATH	IS_BINARY	REGISTER_REPORTS
GET_EXPANDED_OSD_PATH	IS_BINARY_WRAPPER	VALIDATE_SIZE_CLAUSE

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