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 is now availble. If you haven't you downloaded already: Why?

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