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.
対策
One can click the "visible columns" button on the icon bar to enable SQL_ID in the Session Browser. Select the desired Session column.
