SGA trace Export Dataset Missing SQL Statement (4277680)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SGA trace Export Dataset Missing SQL Statement
Description

When exporting the grid of the SGA Trace, the column SQL Text which is the first in the grid, is not exported to the excel file.
Resolution
WORKAROUND
1. Open SGA Trace and refresh to show records.
2. Right-click in Right Hand Side grid - Export Dataset.
3. In columns to exclude: uncheck 'LONG'.
4. Select Excel Instance and Ok.
Result: SQL_TEXT shows as first column in the excel spreadsheet.
STATUS
Waiting for fix in a future release of Toad for Oracle.
Defect ID

CR115595

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title