[Home] [Help] [Dependency Information]
Object Name: | DBA_WORKLOAD_REPLAYS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
|
|
|