Real Time SQL Monitoring Support in Oracle SQL Developer [Video]

thatjeffsmith SQL Developer 5 Comments

Tell Others About This Story:

I had a pretty good week of presenting at Open World this week. 3 solo presentations, all well attended. But in one, I had a technical issue – that’s code for I was having problems because I was using the wrong database connection – when trying to show off the Real Time SQL Monitoring support feature in Oracle SQL Developer.

So in case you were there, and left a bit disappointed, I cut this quick 4 minute video.

The Basics, In Print

This post was one of the very first I published about SQL Developer three years ago. One thing I didn’t mention there is that you can control access to this feature by connection. So if you don’t have the Tuning Pack licensed across all of your databases, you can keep yourself from accidentally accessing it.

Enable the feature by database. For new connections, you'll be prompted before the feature is accessed.

Enable the feature by database. For new connections, you’ll be prompted before the feature is accessed.

If you need more help, just talk to your account manager, and I’m sure they can help you sort it out such that you have access to it for all of your instances 🙂

Tell Others About This Story:

Comments 5

  1. Is there any way we can format number with comma in the SQL detail report for SQL monitor in SQL developer like 1,000,000

  2. turned on option “Upper keywords” as I type makes code like this. The same when I use ctrl+’.

    BEGIN
    loop
    END loop;
    END;
    /

    ctrl-F7 makes code

    BEGIN
    LOOP
    END LOOP;
    END;
    /

    it looks like bug. Not all people use CTRL=F7. Can you fix it in next release. There are many important keywords that are ignored with “Upper keywords” as I type.

    CTRL+’ != CTRL+F7

    Regards
    Tomasz

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *