Oracle | DBMS_WRR

Oracle DBMS_WRR_PROTECTED Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Supporting utilities for Workload Replay

AUTHID CURRENT_USER

Dependencies

ALL_OBJECTS	DBMS_WORKLOAD_CAPTURE_I	DBMS_WRR_INTERNAL
DBMS_PRIV_CAPTURE	DBMS_WORKLOAD_CAPTURE_LIB	PRVT_SMGUTIL
DBMS_STANDARD	DBMS_WORKLOAD_REPLAY	X$DBREPLAY_PATCH_INFO
DBMS_SYS_ERROR	DBMS_WORKLOAD_REPLAY_I	XS_ADMIN_UTIL
DBMS_WORKLOAD_CAPTURE	DBMS_WORKLOAD_REPLAY_LIB

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted.

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvtwrr.plb

Subprograms

CHECK_DIR_ACCESS	GET_DBVERSION_NUM	INVOKE_XCACHE_FREE
CHECK_RAT_PRIVILEGE	GET_DBVERSION_TXT	INVOKE_XCACHE_LOAD
GET_DBREPLAY_PATCH_INFO	INVOKE_SIMPLE_CMD

CHECK_DIR_ACCESS

Undocumented dbms_wrr_protected.dcheck_dir_access( dir IN VARCHAR2, check_write IN BOOLEAN);

TBD

CHECK_RAT_PRIVILEGE

Undocumented dbms_wrr_protected.check_rat_privilege(auth_type IN BINARY_INTEGER);

exec dbms_wrr_protected.check_rat_privilege(1);

           *

      PLS-00904: insufficient privilege to access object DBMS_WRR_PROTECTED

GET_DBREPLAY_PATCH_INFO

Undocumented dbms_wrr_protected.get_dbreplay_patch_info RETURN VARCHAR2;

SELECT dbms_wrr_protected.get_dbreplay_patch_info;

      *

      PLS-904: insufficient privilege to access object DBMS_WRR_PROTECTED

GET_DBVERSION_NUM

Undocumented but assumed to returned the database version in numeric form dbms_wrr_protected.get_dbversion_num RETURN NUMBER;

SELECT dbms_wrr_protected.get_dbversion_num;

      *

      PLS-904: insufficient privilege to access object DBMS_WRR_PROTECTED

GET_DBVERSION_TXT

Undocumented but assumed to return the database version number in text form dbms_wrr_protected.get_dbversion_txt RETURN VARCHAR2;

SELECT dbms_wrr_protected.get_dbversion_txt;

      *

      PLS-904: insufficient privilege to access object DBMS_WRR_PROTECTED

INVOKE_SIMPLE_CMD

Undocumented but is likely performing a dynamic SQL execution

Overload 1 dbms_wrr_protected.invoke_simple_cmd( cmd_num IN BINARY_INTEGER, ret_str OUT VARCHAR2) RETURN NUMBER;

TBD

Overload 2 dbms_wrr_protected.invoke_simple_cmd(cmd_num IN BINARY_INTEGER) RETURN NUMBER;

TBD

INVOKE_XCACHE_FREE

Undocumented dbms_wrr_protected.invoke_xcache_free;

exec dbms_wrr_protected.invoke_xcache_free;

           *

      PLS-00904:  insufficient privilege to access object DBMS_WRR_PROTECTED

INVOKE_XCACHE_LOAD

Undocumented dbms_wrr_protected.invoke_xcache_load( sql_stmt IN VARCHAR2, num_ub4_defines IN BINARY_INTEGER, num_str_defines IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD