Unfortunately SQL statements are not available in the Spotlight History Browser. Here is a list of items that are not available in the History Browser.
Data That Does Not Appear in The History Browser
Certain features in Spotlight on Oracle cannot be captured for display in the Spotlight History browser, even when the relevant Spotlight options are chosen. The features that cannot be collected in historical snapshots are:
The SQL & Application Workload Drilldown.
The Activity Drilldown | Waits Page | Grid.
The Activity Drilldown | ( Waiting Events Page (Oracle 10g and later) | Waiting Events Page (Oracle 9i))
The I/O Drilldown | Summary Page | Bottom chart.
The Configuration & Memory Drilldown | Buffer Cache Page | lower grid.
The Configuration & Memory Drilldown | Oracle Parameters Page.
The Operating System Drilldown | OS Storage Page.