CODEWITHSUNDEEP
oracle-databaseoracle12c
general46
general46

Reputation: 820

SQL Monitoring Window

I tried to use real time sql monitoring tool, but once I started, all the tools bar at the top of the window are grayed out, and once I run the sql query, nothing happens in the monitor window.

The tool is Oracle Enterprise Manager.

Do you know how to make it work or need some special permission?

Thanks in advance for your help.

Upvotes: 0

Views: 514

Answers (2)

thatjeffsmith
thatjeffsmith

Reputation: 22427

Make sure your database user has privileges on data dictionary views like:

  • gv$active_session_history
  • gv$sql_monitor
  • gv$sql_monitor
  • gv$sql_plan_monitor

(DOCS)

If you're still having issues with EM, then SQL Developer also has an interface for RTSM on the Tools Menu:

enter image description here

Upvotes: 1

APC
APC

Reputation: 146209

The Real Time SQL Monitoring tool in Oracle Enterprise Manager (or SQL Developer) requires Enterprise Edition and the Diagnostics and Tuning options (chargeable extras to the EE license). Find out more.

Are you connecting as a SYSDBA account? If not, that might account for the menu items being disabled. However, you should check that your organisation has the necessary licenses before using this feature.

Upvotes: 2

Related Questions