How to get the SQL ID and other session details not shown in Top Session Finder
说明
When Top Session Finder is run, it shows the sessions in the database that are consuming the most resources. How can you retrieve additional information about a highlighted session, e.g. Current Statement, waits locks etc?
解决办法
In the Top Session Finder, select the session you want to locate
Click the button above the data grid to Find Selected Session in Session Browser
Session Browser will launch and display information for the highlighted session.