I cannot see all queries with
gv$sql_monitor. I can see some queries, none of which have
/*+ MONITOR */. I have tested a query with MONITOR and it still did not show. I thought it might just be a big explain problem, so I adjusted my session with:
ALTER SESSION SET "_SQLMON_MAX_PLAN"=4020; ALTER SESSION SET "_SQLMON_MAX_PLANLINES"=4000; select first_refresh_time, last_refresh_time, status, sql_text from v$sql_monitor order by last_refresh_time desc;
, but it didn't help. What I am trying to do is see query submitted via an application. The query works, so I know it is hitting the database. I simply cannot see the query in Oracle.
What am I doing wrong? I am using SQL Developer if that matters.