Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
678 views
1 mention