Long SQL statements are not completely shown in Top SQL tab. The same problem also exists in Reports in which complete statements in Top SQL are not shown for extremely long statements.
Sql_Text displayed in the Top SQL grid is limited to 1000 chars even if you copy to clipboard. We get the "Sql_Text" col from V$Sql which is a varchar2(1000). By changing datatype in column to "Sql_FullText" a full statement should be retrieved from dynamic view.
Download and apply the attached patch.
Steps to apply:
1. Backup the template (SpotlightOnOracle.stx) file in the <Spotlight dir>\console\template directory and extract the same named file in the attached zip.
2. Extract the "support.dat" from the attached zip into the <Spotlight dir>\plug-ins\SoO directory
3. Start Spotlight and connect
Enhancement request CR14674 has been submitted to Development for consideration in a future release of Spotlight on Oracle.