DBA_WORKLOAD_CAPTURES

6.117 DBA_WORKLOAD_CAPTURES

DBA_WORKLOAD_CAPTURES displays all the workload captures that have been performed in the current database.

It also lists captures on which DBMS_WORKLOAD_CAPTURE.GET_CAPTURE_INFO() or DBMS_WORKLOAD_REPLAY.GET_REPLAY_INFO() have been called. Each row contains information about one workload capture.

Column	Datatype	NULL	Description
`ID`	`NUMBER`	`NOT NULL`	Internal key for the workload capture
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name for the workload capture
`DBID`	`NUMBER`	`NOT NULL`	ID of the database in which the workload was captured
`DBNAME`	`VARCHAR2(10)`	`NOT NULL`	Name of the database in which the workload was captured
`DBVERSION`	`VARCHAR2(17)`	`NOT NULL`	Version of the database in which the workload was captured
`PARALLEL`	`VARCHAR2(3)`		Indicates whether the database in which the workload was captured is an Oracle RAC database (`YES`) or a single instance database (`NO`)
`DIRECTORY`	`VARCHAR2(128)`	`NOT NULL`	Name of the directory object for workload capture
`STATUS`	`VARCHAR2(40)`	`NOT NULL`	Current status of the workload capture: `IN PROGRESS` - Workload capture is in progress `COMPLETED` - Workload capture has completed successfully `FAILED` - Workload capture was aborted due to errors encountered
`START_TIME`	`DATE`	`NOT NULL`	Datetime when the capture began
`END_TIME`	`DATE`		Datetime when the capture completed or failed; NULL if the capture is still in progress
`DURATION_SECS`	`NUMBER`		Duration of the workload capture (in seconds)
`START_SCN`	`NUMBER`	`NOT NULL`	Start SCN value for this capture
`END_SCN`	`NUMBER`		End SCN value for this capture; NULL if the capture is still in progress
`DEFAULT_ACTION`	`VARCHAR2(30)`	`NOT NULL`	Mode in which to apply workload capture filters: `INCLUDE` - All the capture filters are treated as EXCLUSION filters, determining the workload that will not be captured. `EXCLUDE` - All the capture filters are treated as INCLUSION FILTERS, determining the workload that will be captured.
`FILTERS_USED`	`NUMBER`		Number of filters that were used for this capture
`CAPTURE_SIZE`	`NUMBER`		Total size of workload capture
`DBTIME`	`NUMBER`		Total amount of database time (in microseconds) that has been recorded in this workload capture
`DBTIME_TOTAL`	`NUMBER`		Total amount of database time (in microseconds) across the entire database during the workload capture, including the part of the workload that was not captured.
`USER_CALLS`	`NUMBER`		Total number of user calls that have been recorded in this workload capture
`USER_CALLS_TOTAL`	`NUMBER`		Total number of user calls across the entire database during the workload capture, including the part of the workload that was not captured.
`USER_CALLS_UNREPLAYABLE`	`NUMBER`		Total number of user calls that will not be replayed in a subsequent replay of this workload capture
`PLSQL_SUBCALL_SIZE`	`NUMBER`		Total size of workload capture for SQL executed from PL/SQL
`PLSQL_CALLS`	`NUMBER`		Total number of PL/SQL calls recorded in the workload capture
`PLSQL_SUBCALLS`	`NUMBER`		Total number of calls recorded in the workload capture for SQL executed from PL/SQL
`PLSQL_DBTIME`	`NUMBER`		Total amount of database time (in microseconds) from PL/SQL calls that have been recorded in the workload capture
`TRANSACTIONS`	`NUMBER`		Total number of transactions that have been recorded in this workload capture
`TRANSACTIONS_TOTAL`	`NUMBER`		Total number of transactions across the entire database during the workload capture, including the part of the workload that was not captured.
`CONNECTS`	`NUMBER`		Total number of session connects that have been recorded in this workload capture
`CONNECTS_TOTAL`	`NUMBER`		Total number of session connects across the entire database during the workload capture, including the part of the workload that was not captured
`ERRORS`	`NUMBER`		Total number of errors that have been recorded in this workload capture
`AWR_DBID`	`NUMBER`		Database ID of the AWR snapshots that correspond to this workload capture. For captures that were performed in the current database, this value is equal to the current database's DBID. For captures that were performed in other databases, this value will either be NULL or will be populated by `DBMS_WORKLOAD_CAPTURE.IMPORT_AWR()`.
`AWR_BEGIN_SNAP`	`NUMBER`		Begin snapshot ID of the AWR snapshots that correspond to this workload capture
`AWR_END_SNAP`	`NUMBER`		End snapshot ID of the AWR snapshots that correspond to this workload capture
`AWR_EXPORTED`	`VARCHAR2(12)`		Indicates whether the AWR snapshots that correspond to this workload capture have been exported using `DBMS_WORKLOAD_CAPTURE.EXPORT_AWR()` (`YES`) or not (`NO`), or whether AWR snapshots cannot be exported because the capture is still in progress, has run to completion successfully, or was done in a different database from which it was not exported (`NOT POSSIBLE`)
`ERROR_CODE`	`NUMBER`		Error code for this workload capture
`ERROR_MESSAGE`	`VARCHAR2(512)`		Error message for this workload capture
`DIR_PATH`	`VARCHAR2(4000)`	`NOT NULL`	Full directory path for the workload capture directory object
`DIR_PATH_SHARED`	`VARCHAR2(10)`	`NOT NULL`	Indicates whether the workload capture directory is shared by all the instances of the recording database (applicable only for Oracle RAC databases)
`LAST_PROCESSED_VERSION`	`VARCHAR2(128)`		Database version in which this capture was preprocessed using `DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE()` last; NULL if the capture has never been preprocessed
`SQLSET_OWNER`	`VARCHAR2(128)`		User name of the SQL tuning set owner
`SQLSET_NAME`	`VARCHAR2(128)`		Name of the SQL tuning set for this workload capture
`PLSQL_MODE`	`VARCHAR2(12)`		Capture options for PL/SQL calls. Possible values: `TOP_LEVEL`: Top-level PL/SQL only `EXTENDED`: Both top-level PL/SQL and SQL executed from PL/SQL
`ENCRYPTION`	`VARCHAR2(128)`		Indicates the encryption standard used for the given capture: NULL - Capture files are not encrypted `AES128` – Capture files are encrypted using AES128 `AES192` – Capture files are encrypted using AES192 `AES256` – Capture files are encrypted using AES256
`ENCRYPTION_VERIFIER`^Foot 1	`RAW(512)`		Data used internally for creating an encrypted capture

^Footnote 1This column is available starting with Oracle Database 19c, Release Update 19.7.