1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. DBA_WORKLOAD_CAPTURE_SQLTEXT

7.117 DBA_WORKLOAD_CAPTURE_SQLTEXT

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: