Oracle | DBMS_WRR_STATE

Oracle DBMS_WRR_STATE_BASE 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 Returns a flag indicating whether the current session is being captured or replayed with RAT

AUTHID DEFINER

Dependencies

DBMS_RANDOM	DBMS_WORKLOAD_REPLAY_LIB	DBMS_WRR_STATE
DBMS_WORKLOAD_CAPTURE_LIB

Documented No

First Available 20c

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(DEFAULT, NONE);
PRAGMA restrict_references (dbms_wrr_state_base, WNDS);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmswrr_state.sql

Subprograms

GET_CAPTURE_STATE

GET_REPLAY_STATE

GET_CAPTURE_STATE (new 20c)

Returns 1 if the session is being captured, else 0 dbms_wrr_state_base.get_capture_state RETURN BINARY_INTEGER;

SELECT dbms_wrr_state_base.get_capture_state

      FROM dual;

      

      GET_CAPTURE_STATE

      -----------------

                      0

GET_REPLAY_STATE (new 20c)

Returns 1 if the session is being replayed, else 0 dbms_wrr_state_base.get_replay_state RETURN BINARY_INTEGER;

SELECT dbms_wrr_state_base.get_replay_state

      FROM dual;

      

      GET_REPLAY_STATE

      ----------------

                     0