Oracle教程

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

本站中文解释

Oracle视图是数据库存取信息的一种有效形式，它们能够提供用户们来代替以有限的系统表以外的另一种方式看待制定数据库的动态内容。 DBA_WORKLOAD_CAPTURE_SQLTEXT用来捕获当前正在运行的SQL语句的文本信息。通过该视图，用户将会得到当前正在运行的SQL语句文本，并可以使用它去执行，进而可以改善SQL的性能。

官方英文解释

DBA_WORKLOAD_CAPTURE_SQLTEXT displays all the SQL statements that have been recorded in a workload capture. For those SQL statements whose length exceeds 1000 characters, the full statements can be loaded to the DBA_WORKLOAD_LONG_SQLTEXT view using the DBMS_WORKLOAD_REPLAY.LOAD_LONG_SQLTEXT procedure.

Column Datatype NULL Description

CAPTURE_ID

NUMBER(38)

NOT NULL

Internal key for the workload capture

SQL_ID

VARCHAR2(13)

NOT NULL

SQL identifier of the parent cursor in the library cache

SQL_TYPE

VARCHAR2(64)

Type of the SQL statement, which can include values such as INSERT, SELECT, and CREATE INDEX

SQL_TEXT

VARCHAR2(1000)

First thousand characters of the SQL text for the current cursor

SQL_LENGTH

NUMBER(38)

The length of the SQL statement

SQL_TEXT_COMPLETE

CHAR(1)

Indicates whether the SQL_TEXT column includes the full text of the SQL statement. Possible values:

  • Y: The column SQL_TEXT includes the full text of the SQL statement

  • N: The column SQL_TEXT contains only the first thousand characters of the SQL text

See Also:

  • “DBA_WORKLOAD_LONG_SQLTEXT”

  • “DBA_RAT_CAPTURE_SCHEMA_INFO”

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


数据运维技术 » Oracle 视图 DBA_WORKLOAD_CAPTURE_SQLTEXT 官方解释，作用，如何使用详细说明
分享到：

相关推荐