One of the base features of Oracle SQL Developer Web is the Performance Hub. This performance diagnostics feature might be familiar to you if you have ever used EM Express.

You’ll have also seen this in our Autonomous Database Cloud Services, and I’ve talked about that before.

Blog: Perf Hub in Oracle Autonomous Database
Video (25 minutes): Perf Hub tour in Autonomous

Where is it?

If you have a DBA level user account (and of course if you have licensed the Diagnostic and Tuning Packs), you can use PerfHub and the Real Time SQL Monitoring inside it via SQL Developer Web.

There are two user interface entry points for the Performance Hub. When you start a SQL Developer Web session as a DBA privileged user, you’ll see a box for it on the right.

Clicking on the Hamburger navigation button in the top left gives you access to this Dashboard or SQL Developer Web-proper screens.

Or, if I’m tooling around in the Worksheet, and I want help with a query…

Charts, graphs, data…oh my!

Powered by ORDS and JET

The EM team built this feature using Oracle JET and ORDS. So it was VERY easy for us to drop it right into SQL Developer Web.

That means you’re seeing the same data/features/presentation as you’d see it anywhere else the EM team is delivering this information.

A quick GIF demo of the SQL Monitor

Remember, you need the Tuning Pack to use this feature.

Author

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

Write A Comment