Is anyone familiar enough with both SQL Dev and Quest's "SQL Navigator" (actually, I think Dell owns it now).
We are reviewing our licensing for SQL Nav and looking to reduce or eliminate it to save $$. For myself, there are a couple of nice features in SQL Nav that I've not found duplicated in SQL Dev (4.0) but I'll be the first to admit I've not really explored very much.
The first feature is a 'code search'. Enter a string, and it will list all pl/sql procs, pkgs, triggers, etc that have that string, with a little bit of context. Configurable for exactly how it determines a match and the scope of the search.
The other feature is 'session browser'. Lists all the sessions. Basic list shows username, schema, status, os user, client machine, terminal, SID, logon time, client executable pgm, etc, with drill down tabs for various items. Of these, the ones I make good use of are
- IO
- block gets
- consitent gets
- physical reads
- block changes
- waits
- event
- wait_time
- second_in_wait
- state
- p1,2,3 and their text
- current sql
- locks
- long ops
If the above looks like a plug for SQL Nav, it is certainly not meant to be. I'd actually like to get rid of it and save the money, if I can be shown that the above functionality is available in SQL Dev.
Other than the above, the use of SQL Nav is really just as a GUI coding environment, so moving the developers to SQL Dev would just be a little learning curve to get used to the new GUI.