I'm trying to get the real time sql monitor report in Oracle 23 Free DB.
Though I provide the /*+ monitor */ hint to my query, the query is not being reported in v$sql_monitor view.
Also, I'm not able to generate real time report using DBMS_SQLTUNE.report_sql_monitor view.The same steps works in 19c DB.
I'm doing this..
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 FREEPDB1 READ WRITE NO
SQL> SELECT sql_id, status, sql_text FROM v$sql_monitor;
no rows selected
SQL>
SQL> select /*+monitor */ * from oe.order_items join oe.orders on oe.order_items.order_id=oe.orders.order_id;
...
...
665 rows selected.
SQL> SELECT sql_id, status, sql_text FROM v$sql_monitor;
no rows selected
SQL>