eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: SYS.WRR$_REPLAYS

Object Details

Object Name:	WRR$_REPLAYS
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: WRR$_REPLAYS_PK

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRR$_REPLAYS_PK	NORMAL	UNIQUE	SYSTEM	ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes
NAME	VARCHAR2	(128)	Yes
DBID	NUMBER		Yes
DBNAME	VARCHAR2	(10)	Yes
DBVERSION	VARCHAR2	(128)	Yes
DIRECTORY	VARCHAR2	(128)	Yes
DIR_PATH	VARCHAR2	(4000)	Yes
CAPTURE_ID	NUMBER
STATUS	VARCHAR2	(40)	Yes	One of "PREPARE", "IN PROGRESS", "COMPLETED", "CANCELLED" or "FAILED"
PREPARE_TIME	DATE
START_TIME	DATE
END_TIME	DATE
NUM_CLIENTS	NUMBER		Yes
NUM_CLIENTS_DONE	NUMBER		Yes
DEFAULT_ACTION	VARCHAR2	(30)	Yes	One of "INCLUDE" or "EXCLUDE"
SYNCHRONIZATION	NUMBER		Yes
CONNECT_TIME_SCALE	NUMBER		Yes
THINK_TIME_SCALE	NUMBER		Yes
THINK_TIME_AUTO_CORRECT	NUMBER		Yes
AWR_DBID	NUMBER
AWR_BEGIN_SNAP	NUMBER
AWR_END_SNAP	NUMBER
AWR_EXPORTED	NUMBER
ERROR_CODE	NUMBER
ERROR_MSG	VARCHAR2	(300)
COMMENTS	VARCHAR2	(4000)
PREPROCESSING_ID	NUMBER
REPLAY_DIR_NUMBER	NUMBER
SCALE_UP_MULTIPLIER	NUMBER		Yes
DIVERGENCE_DETAILS_STATUS	VARCHAR2	(40)
REPLAY_TYPE	VARCHAR2	(10)
SQLSET_OWNER	VARCHAR2	(128)
SQLSET_NAME	VARCHAR2	(128)
SQLSET_CAP_INTERVAL	NUMBER
FILTER_SET_NAME	VARCHAR2	(1000)
SCHEDULE_NAME	VARCHAR2	(128)
NUM_ADMINS	NUMBER
DIVERGENCE_LOAD_STATUS	VARCHAR2	(5)
INTERNAL_START_TIME	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      NAME
,      DBID
,      DBNAME
,      DBVERSION
,      DIRECTORY
,      DIR_PATH
,      CAPTURE_ID
,      STATUS
,      PREPARE_TIME
,      START_TIME
,      END_TIME
,      NUM_CLIENTS
,      NUM_CLIENTS_DONE
,      DEFAULT_ACTION
,      SYNCHRONIZATION
,      CONNECT_TIME_SCALE
,      THINK_TIME_SCALE
,      THINK_TIME_AUTO_CORRECT
,      AWR_DBID
,      AWR_BEGIN_SNAP
,      AWR_END_SNAP
,      AWR_EXPORTED
,      ERROR_CODE
,      ERROR_MSG
,      COMMENTS
,      PREPROCESSING_ID
,      REPLAY_DIR_NUMBER
,      SCALE_UP_MULTIPLIER
,      DIVERGENCE_DETAILS_STATUS
,      REPLAY_TYPE
,      SQLSET_OWNER
,      SQLSET_NAME
,      SQLSET_CAP_INTERVAL
,      FILTER_SET_NAME
,      SCHEDULE_NAME
,      NUM_ADMINS
,      DIVERGENCE_LOAD_STATUS
,      INTERNAL_START_TIME
FROM SYS.WRR$_REPLAYS;

Dependencies

[top of page]

SYS.WRR$_REPLAYS does not reference any database object

SYS.WRR$_REPLAYS is referenced by following:

SYS: AS_REPLAY - show dependent code; DBA_WORKLOAD_ACTIVE_USER_MAP; DBA_WORKLOAD_FILTERS; DBA_WORKLOAD_REPLAYS; DBA_WORKLOAD_REPLAY_DIVERGENCE; DBMS_RAT_MASK - show dependent code; DBMS_WORKLOAD_REPLAY - show dependent code; DBMS_WRR_INTERNAL - show dependent code