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]

VIEW: SYS.DBA_WORKLOAD_REPLAYS

Object Details

Object Name:	DBA_WORKLOAD_REPLAYS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ID	NUMBER		Yes
NAME	VARCHAR2	(128)	Yes
DBID	NUMBER		Yes
DBNAME	VARCHAR2	(10)	Yes
DBVERSION	VARCHAR2	(128)	Yes
PARALLEL	VARCHAR2	(3)
DIRECTORY	VARCHAR2	(128)	Yes
CAPTURE_ID	NUMBER
STATUS	VARCHAR2	(40)	Yes
PREPARE_TIME	DATE
START_TIME	DATE
END_TIME	DATE
DURATION_SECS	NUMBER
NUM_CLIENTS	NUMBER		Yes
NUM_CLIENTS_DONE	NUMBER		Yes
FILTER_SET_NAME	VARCHAR2	(1000)
DEFAULT_ACTION	VARCHAR2	(30)	Yes
SYNCHRONIZATION	VARCHAR2	(9)
CONNECT_TIME_SCALE	NUMBER		Yes
THINK_TIME_SCALE	NUMBER		Yes
THINK_TIME_AUTO_CORRECT	VARCHAR2	(5)
SCALE_UP_MULTIPLIER	NUMBER		Yes
USER_CALLS	NUMBER
DBTIME	NUMBER
NETWORK_TIME	NUMBER
THINK_TIME	NUMBER
PAUSE_TIME	NUMBER
ELAPSED_TIME_DIFF	NUMBER
AWR_DBID	NUMBER
AWR_BEGIN_SNAP	NUMBER
AWR_END_SNAP	NUMBER
AWR_EXPORTED	VARCHAR2	(12)
ERROR_CODE	NUMBER
ERROR_MESSAGE	VARCHAR2	(300)
DIR_PATH	VARCHAR2	(4000)	Yes
REPLAY_DIR_NUMBER	NUMBER
SQLSET_OWNER	VARCHAR2	(128)
SQLSET_NAME	VARCHAR2	(128)
SCHEDULE_NAME	VARCHAR2	(128)
DIVERGENCE_LOAD_STATUS	VARCHAR2	(5)

Query Text

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


SELECT ID
,      NAME
,      DBID
,      DBNAME
,      DBVERSION
,      PARALLEL
,      DIRECTORY
,      CAPTURE_ID
,      STATUS
,      PREPARE_TIME
,      START_TIME
,      END_TIME
,      DURATION_SECS
,      NUM_CLIENTS
,      NUM_CLIENTS_DONE
,      FILTER_SET_NAME
,      DEFAULT_ACTION
,      SYNCHRONIZATION
,      CONNECT_TIME_SCALE
,      THINK_TIME_SCALE
,      THINK_TIME_AUTO_CORRECT
,      SCALE_UP_MULTIPLIER
,      USER_CALLS
,      DBTIME
,      NETWORK_TIME
,      THINK_TIME
,      PAUSE_TIME
,      ELAPSED_TIME_DIFF
,      AWR_DBID
,      AWR_BEGIN_SNAP
,      AWR_END_SNAP
,      AWR_EXPORTED
,      ERROR_CODE
,      ERROR_MESSAGE
,      DIR_PATH
,      REPLAY_DIR_NUMBER
,      SQLSET_OWNER
,      SQLSET_NAME
,      SCHEDULE_NAME
,      DIVERGENCE_LOAD_STATUS
FROM SYS.DBA_WORKLOAD_REPLAYS;

Dependencies

[top of page]

SYS.DBA_WORKLOAD_REPLAYS references the following:

SYS: WRR$_REPLAYS; WRR$_REPLAY_STATS

SYS.DBA_WORKLOAD_REPLAYS is referenced by following:

PUBLIC: DBA_WORKLOAD_REPLAYS
SYS: DBMS_FEATURE_WCR_REPLAY - show dependent code; DBMS_WORKLOAD_REPLAY - show dependent code; DBMS_WRR_INTERNAL - show dependent code; PRVT_CPADDM - show dependent code