Wait, I thought SQL Developer was for developers?

Yes, but it also provides a ton of features and value for the DBA. So if you’re already in SQL Developer to browse a table or run a query, you can fire up the DBA features under the View menu (and maybe save yourself an alt-tab to your browser and OEM.)

We had a nice live webcast today with the good folks at ODUTG on this subject. If you’re a member in good standing, you can watch that recording here later this week.

In the meantime, here’s a 36 slide overview to get you interested in learning more.

I also have a few posts on the subject..that is, how to do DBA stuff in SQL Developer:

thatjeffsmith
Author

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

2 Comments

  1. I have just had to recompile a whole load of packages and functions and I selected the folder and clicked compile all, now all of the packages are compiled for debug. Is this by design as I don’t remember previous versions compiling in this way?
    Can this behaviour be disabled via preferences

    Version 4.0.0.13
    Build MAIN-13.80

    • thatjeffsmith

      Check the SQL panel on the compile prompt. Does it say “compile” or “compile debug” ?

Write A Comment