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:
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
Check the SQL panel on the compile prompt. Does it say “compile” or “compile debug” ?