7.123 DBA_WORKLOAD_LONG_SQLTEXT
DBA_WORKLOAD_LONG_SQLTEXT
displays the captured SQL statements that are longer than 1000 characters. You can load SQL statements longer than 1000 characters to the DBA_WORKLOAD_LONG_SQLTEXT
view using the DBMS_WORKLOAD_REPLAY.LOAD_LONG_SQLTEXT
procedure.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Internal key for the workload capture |
|
|
|
SQL identifier of the parent cursor in the library cache |
|
|
|
Full text for the SQL statement exposed as a CLOB column |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for information about the
DBMS_WORKLOAD_REPLAY
package