I just came from a DBA-dominated conference – Hotsos Symposium in Dallas, if you must know – and I came away with the impression that many a DBA out there is missing out on some key features and productivity-hacks in our dear ole IDE.
I could give you 10 things, but I know DBAs are busy, so here are just 3:
1.)The Instance Viewer
New since 2014 and version 4.1. Nothing to install in your database, just quickly give me an idea of what’s happening, and let me quickly drill-into the details.
Speaking of details…
2.)Tablespace Stuff
Everyone always asks, can I use SQL Developer to work on my data files? The answer is of course, yes!
![You can click into a tablespace from this chart or open directly from the tree. USERS looks kinda full to me.](https://www.thatjeffsmith.com/wp-content/uploads/2014/04/tablespace10.png)
And yeah, we have dialogs for all the work stuff:
3.)Create User Scripts
This one is a bit of a trick, but you can quickly generate all the DDL for a user, including the their object and role grants and privs.
![I'm splitting the object editor here to show the different panels concurrently.](https://www.thatjeffsmith.com/wp-content/uploads/2015/12/hr_user_1.png)
But you want the actual script, so right-click, and choose Create Like, toggle ‘include object privs’ and then go to the SQL page of the dialog.
Voila.
![Yes, it includes all of the object grants for HR.](https://www.thatjeffsmith.com/wp-content/uploads/2016/03/clone_user_script.png)
BONUS 4.)We have interfaces for both ADDM/AWR/ASH
If you’re already in SQL Developer, and you want to see an ASH report, be our guest 🙂
3 Comments
The ASH report is really cool, and the DBA can give access to the developer with just grant on dbms_workload_repository.
Unfortunately ASH often hangs when using case insensitive databases, but this is not a sqldeveloper issue (bug 12764391)
case insensitive databases => are those really a thing? If so, how do we drop them?
Ha!