Oracle 视图 DBA_WORKLOAD_CAPTURES 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图DBA_WORKLOAD_CAPTURES,是查看数据库凭据分析的诊断信息的工具。它提供了有关当前运行的Workload Capture的属性和结果的信息,例如捕获类型、时间戳、状态及捕获文件等。

使用方法:

1. 首先,需要使用数据库视图v$session_longops来显示正在运行的Workload Capture操作,它将存储当前运行捕获和捕获创建者的会话。

2. 其次,使用DBA_Workload_Captures视图查询当前运行的Workload Capture任务。

3. 最后,使用Net Manager或其他网络工具来查看Workload Capture的结果,或使用SQL*Plus来解析捕获中的SQL语句。

官方英文解释

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(128)

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

RAW(512)

 

Data used internally for creating an encrypted capture

PATCH_NAME

VARCHAR2(128)

 

Database workload capture and replay patch name

This column is populated only for backports to Oracle Database 12c Release 1 (12.1) and earlier releases.

STORAGE_TYPE

NUMBER(38)

 

Describes where the captured workload is stored

See Also:

  • Oracle Database PL/SQL
    Packages and Types Reference
    for more information about the DBMS_WORKLOAD_CAPTURE package

  • Oracle Database PL/SQL
    Packages and Types Reference
    for more information about the DBMS_WORKLOAD_REPLAY package


数据运维技术 » Oracle 视图 DBA_WORKLOAD_CAPTURES 官方解释,作用,如何使用详细说明