Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to generate real time report using DBMS_SQLTUNE.report_sql_monitor view

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>
This post has been answered by user9540031 on Jun 23 2023
Jump to Answer
Comments
Post Details
Added on Jun 23 2023
2 comments
760 views