We installed Performance Analysis Oracle in the production environment and noticed we're not able to see the "Traced SQL" tab when drilling down into Real-Time Current Sessions to view detail for a specific Session ID.
Is there any setting that would prohibit this tab from displaying? We have the Current SQL and SQL Summary tabs (along with several others) but no Traced SQL.
The "Group execution of identical SQL statements within a session" option is enabled in Resource Saving Options
Try these steps to enable the Traced SQL tab:
1. Launch Agent Administration and click on Agent Options
2. Select the Resource Saving Options tab
3. Click the "Group execution of identical SQL statements within a session" to clear the checkbox (checkbox should be unchecked)
4. Click Apply | Ok and verify the Traced SQL tab is displayed