Return
-
Title
I need the SQL_ID in Session Monitor -
Description
I use the Session Monitor frequently to monitor active queries.
When a query uses bind variables, it forces me to go to the editor and query V$SQL_BIND_CAPTURE.
In order to query that view, I need the sql_id which the Session Monitor does not provide.
Currently, I either switch to Oracles dbmonitor/Enterprise Manager or I try to query the sql_text column in V$SQL.
It would be really nice if the sql_id was provided with the SQL in the Session Monitor. -
Resolution
One can click the "visible columns" button on the icon bar to enable SQL_ID in the Session Browser.
Select the desired Session column.