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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_WORKLOAD_CAPTURE
DBMS_WORKLOAD_REPLAY
DBMS_WORKLOAD_REPOSITORY
DBMS_WRR_INTERNAL
DBMS_WRR_PROTECTED
DBMS_WRR_REPORT
DBMS_WRR_STATE
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx