Oracle SQL Developer for the DBA

thatjeffsmith SQL Developer 2 Comments

Tell Others About This Story:

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:

  • Managing Users and Roles
  • SQL Developer and the Diagnostics Pack
  • Snapshot Findings and ADDM Reports
  • 12c and Multitenant
  • Locks and Killing Sessions
  • Tell Others About This Story:

Comments 2

  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

    1. thatjeffsmith Post
      Author

Leave a Reply

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