Oracle | DBMS_WRR_STATE

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