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

TABLE: SYS.WRR$_SCHEDULE_CAPTURES

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WRR$_SCHEDULE_CAPTURES_PK
  1. ColumnSCHEDULE_NAME
  2. ColumnSCHEDULE_CAP_ID
Indexes
Index Type Uniqueness Tablespace Column
WRR$_SCHEDULE_CAPTURES_PK NORMAL UNIQUE TablespaceSYSAUX ColumnSCHEDULE_NAME
ColumnSCHEDULE_CAP_ID
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_NAME VARCHAR2 (128) Yes
SCHEDULE_CAP_ID NUMBER
Yes
CAPTURE_ID NUMBER
Yes
CAPTURE_DIR VARCHAR2 (128) Yes
OS_SUBDIR VARCHAR2 (4000) Yes
MAX_CONCURRENT_SESSIONS NUMBER

NUM_CLIENTS_ASSIGNED NUMBER

NUM_CLIENTS NUMBER

NUM_CLIENTS_DONE NUMBER

STOP_REPLAY VARCHAR2 (1) Yes
TAKE_BEGIN_SNAPSHOT VARCHAR2 (1) Yes
TAKE_END_SNAPSHOT VARCHAR2 (1) Yes
QUERY_ONLY VARCHAR2 (1) Yes
START_DELAY_SECS NUMBER

DEPENDENT_LEVEL NUMBER

START_TIME DATE

END_TIME DATE

AWR_DBID NUMBER

AWR_BEGIN_SNAP NUMBER

AWR_END_SNAP NUMBER

STATUS VARCHAR2 (128)
Query Text

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


SELECT SCHEDULE_NAME
,      SCHEDULE_CAP_ID
,      CAPTURE_ID
,      CAPTURE_DIR
,      OS_SUBDIR
,      MAX_CONCURRENT_SESSIONS
,      NUM_CLIENTS_ASSIGNED
,      NUM_CLIENTS
,      NUM_CLIENTS_DONE
,      STOP_REPLAY
,      TAKE_BEGIN_SNAPSHOT
,      TAKE_END_SNAPSHOT
,      QUERY_ONLY
,      START_DELAY_SECS
,      DEPENDENT_LEVEL
,      START_TIME
,      END_TIME
,      AWR_DBID
,      AWR_BEGIN_SNAP
,      AWR_END_SNAP
,      STATUS
FROM SYS.WRR$_SCHEDULE_CAPTURES;

Dependencies

[top of page]

SYS.WRR$_SCHEDULE_CAPTURES does not reference any database object

SYS.WRR$_SCHEDULE_CAPTURES is referenced by following:

SchemaSYS
ViewDBA_WORKLOAD_SCHEDULE_CAPTURES
Package BodyDBMS_WORKLOAD_REPLAY - show dependent code