ThatJeffSmith

An Introduction to SQL Developer Extensions

Oracle SQL Developer is made available to you for free, and is chock-full of features for the developer, DBA, or data-junkie. We do our best to give you everything you need to be successful in your job, but also recognize that we can’t do EVERYTHING. While SQL Developer is NOT an open-source project, it does provide a framework that allows for other developers to build their own plug-ins. Don’t know Java? No problem, you can get started with just SQL and XML. Don’t have TIME to build your own software? No problem, other smart people are making their extensions available to you.

These 3rd party extensions range from $0 in price to just a bit more than free.

Jealous of those Android and iOS developers making mad money? Build an extension and share it with your fellow Oracle comrades!

Quick Links

Think You Know What SQL Developer Looks Like?

Oracle Database Monitoring with 4th Elephant Extension

The above image is SQL Developer running a free 3rd party extension from Fourth Elephant. They have an advanced version with much more functionality if you have a few spare dollars to spend. They have another couple of screens that I enjoy using to click through active sessions and wait events.

Think Getting Trace Files is a Pain?

Mr. Trace is another extension that automatically starts a trace and retrieves the file(s) down to SQL Developer so you can analyze the performance of your queries. ‘Before, getting trace files was hard.’ Yeah, if you’re not the UNIX admin or DBA, getting the trace files off the database server is a pain. This plugin requires a few server side objects (that your DBA can create for you), and then makes it a seamless process to access the files afterwards.

Method R's Mr Trace in SQL Developer

Once you’re ready to analyze the trace files, you can open it natively in SQL Developer, or you can spend some money and buy another 3rd party tool, some of which are available on the Extensions Exchange.

SQL Developer Quick Tip: Viewing Trace Files in the Worksheet
This is very easy. You can drag the file to the worksheet, or you can send it directly from the Mr Trace extension.

Quickly read trace files in the worksheet

Why Are You Promoting Someone Else’s Software?

I have one primary goal as a Product Manager – to maximize the SQL Developer’s user experience. That’s a fancy way of saying I want our users to be happy. Happy users equal loyal users. One of the ways I can do this is to shine a bright light on some other smart people out there that are trying to bring value to the users of SQL Developer.

A quick disclaimer or 2:

1 – I’m not endorsing FourthElephant’s or Method R’s extensions. However I think both make great examples of how an extension can work.
B – There are many great ISVs and independent developers I could have highlighted, I just chose the two that caught my eye first.