People seemed to like the Instance Viewer we built for version 4.1.

So we wanted to use similar technology (Java FX) to build a new interface for the Oracle Database Tuning Pack’s Real Time SQL Monitor.

So we did.

If you don’t have EM Express or Enterprise Manager available or handy, you can get the report in all it’s live, refreshing glory, in SQL Developer’s DBA Panel. It’s also on the Tools menu.

A Quick Demo

We sort the queries by run time, so the most recent, and currently running ones should be up top.

the info updates in real time as the query runs

We also make the SQL in question easily accessible – and readable – by giving you the formatted SQL text on a mouse-hover bubble window.

Put your mouse over the SQL cell to see the entire statement.
thatjeffsmith
Author

I'm a Senior Principal Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

13 Comments

  1. I’d love to use this Feature more often, as wouldn’t Need to Switch over to Enterprise Manager.
    In Enterprise Manager I’m able to see the real time plan statistics, but in SQL-Developer the window is greyed out.
    I’m using the same user-identification and don’t know what privilege could be missing. Do you have any idea about that?

    • thatjeffsmith

      Check view > Log > Statements panel. You’ll see the queries we’re running to get that info.

    • Thank you for the fast reply. I found the corresponding SQL and after some adjustment to the Parameter sqlexecstart which was timestamp and not date, the SQL itself ran. So it doesn’t seem to be a privilege-Problem. I’m also unsure if the Parameter and value for sqlexecstart are the Problem, as the metrics-tab works/displays fine and uses the same Parameter.

    • Hi Chris,

      Did you resolve this? As I have exactly the same problem.

      Thanks

  2. Very nice article posted by you on sql monitoring .keep updatin such articles.
    Thank you.

  3. David Bayard Reply

    Jeff- This is a great start. Can you add the Activity% and reporting of individual wait events, just like the real SQL Monitor does? For instance, if you hover over the Activity% in the real SQL Monitor it will show you individual wait events like “cell table smart scan” as you move along the activity% color bar. This individual wait event is available for the overall query and the individual plan lines.

    SQL Developer 4.2 does not have an Activity% for the query as a whole (it has a database time, but that does not show individual wait events). And SQLDev 4.2 does have an Activity% for the plan lines but unlike the real SQL Developer, it does not break out individual wait events.

  4. Client satisfaction and shifting your goods in one single piece without any damage is the main aim and motto of our Company.

  5. Craig Jarchow Reply

    Hi Jeff, the real-time monitoring is a great in SQL Developer.

    One feature from 4.1 which seems to be gone though is the ability to save/export the SQL monitoring results into a web page. This was great for sharing, collaborating, keeping record of issues encountered. Can this be re-instated?

    • thatjeffsmith

      it generated html that would run FLASH off of resources from OTN, and wasn’t compatible with 12c style reports…we need to build a new one. It’s definitely ON the list

    • Arjun Sirohi

      Is there a timeline when we can expect this feature “ability to save/export the SQL monitoring results into a web page” in SQL Developer 4.2?

    • Hi Jeff,

      I don’t see this feature in Version 18.1, are you planning for that ?

      Regards
      Ravi

    • Hi Jeff,

      Would be really great to have this ability to save the SQL monitoring results into a web page or even to a Word document.

      You can also include a report of the database activity history for the last few days/weeks/months.

      These are good for reporting purposes.

      Bob

Write A Comment