CODEWITHSUNDEEP
sqlquery-optimizationoracle-sqldeveloperoracle-database
CFwdAll
CFwdAll

Reputation: 11

accessing Real Time SQL Monitoring in SQL Developer

In Oracle SQL Developer, I do not see Real Time SQL Monitoring, under the "Tools" menu where it should be. I am only seeing Monitor Sessions, which doesn't seem to provide that visual information on the optimizer's behavior, like what Real-Time SQL Monitoring provides I believe.

Details I'm using SQL Developer version 20. I checked, and it looks like I have the required "diagnostics and tuning" pack:

diagnostics and tuning pack

SELECT vd.* from v$parameter vd

I think that this shows I have that required pack, when I check control_management_pack_access.

I looked around in Preferences for SQL Developer, but I don't see any options that look relevant to this.

Alternatives for accessing Real Time SQL Monitor Might I give up on this GUI approach, and try something else to use Real Time SQL Monitoring, like running this code: SELECT dbms_sqltune.report_sql_monitor(sql_id => 'ddga0450ycfsa',report_level => 'ALL',type => 'html') FROM dual;

However, when I run that, what do I do next? I've tried exporting the output to an HTML file, and opening that file in a browser, but it just looks like Greek to me:

opening the resulting HTML file in browser

I'm new to Real Time SQL Monitor, so I don't know what else I may have missed.

Upvotes: 1

Views: 549

Answers (1)

Martin Schapendonk
Martin Schapendonk

Reputation: 13526

Check the Database -> Licensing page in your preferences. Enable the tuning and diagnostics pack for the connection(s) you have the license for. These settings exist to prevent you from violating your license terms.

screenshot database licensing preferences

Image source: thatjeffsmith.com

Upvotes: 1

Related Questions