ORA SPACE

Oracle has released SQL Developer 1.5 (1.5.0.53.38)  last month. I tried that version recently, and found couple of new features that are worth mentioning. Following are the few of the new features that I found useful:

SQL Worksheet

• Flashback. For 10g and 11g, you can use flashback on your data. See the Flashback tab on Tables.
• Separate unshared worksheet for connections for long running queries. Use the keystroke ctrl+shift+N. This will create a separate, unshared worksheet.

Navigator

• Run Manage Database report ( as SYS) to shut down and rest rat database
• Generate DB Doc (right-click for context menu on connections) for all objects in a schema. Open the generated index.html file in a browser to review objects.

Figure 1: Sample output generated using Navigator: Generate DB Doc option

Connections

• Support for LDAP and Authenticated Enterprise users
• OS Authentication

Tuning

• Open *.trc file in SQL Developer for a formatted trace file.

Reports

• ASH and AWR reports

It seems that Oracle is continuously extending the functionalities available in SQL Developer with every new release. However, I am definitely looking for a dashboard kind of reporting for specific or multiple databases. Hope we should be able to get that feature in future from Oracle or via 3rd party extension.

References:

• OTN: SQL Developer Home Page