Oracle | PRVT

Oracle PRVT_EMX Version 21c

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	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