Our 11th update for the year is now available for download in the usual places. And you can find the full changelog here.
We’re committed to bringing the best possible experience, so while we’re delivering major updates every 3 months, we’re also doing MONTLY updates to address the biggest issues reported from our community. So again, THANK YOU for those reports.
Significant New Features
- Reports
- Real Time SQL Monitoring
- Explain plan now supports Cached Plans and DBMS_XPLAN
- Many updates improvements to JSON Relational Duality Views
Significant bug fixes and UI improvements
- We won’t auto-toggle on the details panel in the output when opening PL/SQL sources
- Missing commands in SQLcl, for example, ‘project’
- Unable to disconnect or reconnect a connection after the database session is terminated
- Run/Debug not available for TYPE and TYPE BODY
Here’s a quick preview of what you can expect:
Reports
Reports! We’ll do a full-write up later, but the non-chart type reports should all be available. Note, you cannot write your OWN reports yet, but this is a big step in that direction.
Real Time SQL Monitoring
Accessible from a right-click on your connection. We’ll list the available reports, simply select up top to get the details.
Execution vs Explain Plans
Same as we have in SQL Developer ‘classic,’ you can on an Plan request, optionally choose from cached plans in V$SQL, or you can generate a DBMS_XPLAN query with the proper SQLID to get the text based report..
