SGA Trace Save As Grid option does not export the entire SQL statement. (4223772)

SGA Trace Save As Grid option does not export the entire SQL statement. Issue occurs with larger SQL statements. These statements appear to be truncated in the exported file. The entire SQL is shown under the SQL tab of SGA Trace.

Limitation of v$sqlarea view having a SQL_Text column of 1000 bytes. This view is used to gather SQL statements in the SQL data grid.

As this is a limitation of Oracle v$sqlarea.SQL_TEXT column length of 1000 bytes, try running the below queries in Editor to obtain a list of SQLs and use data grid Save As to export SQLs.

select sql_text
from sys.v_$sqltext
ORDER BY hash_value,piece;

select sql_text
from sys.v_$sqltext_with_newlines
ORDER BY hash_value,piece;