SQL Developer

SQL Developer New Direction - Installing in a secure environment...

Submitted by dave on Mon, 09/30/2024 - 16:16

I'm a fan of SQL Developer, have been for years. I especially like User Defined Reports.
Time for some shameless self promotion!

Here is a presentation I gave to East Coast OUG on 2014 - SQL Developer Reporting. It covers general SQL Developer reporting features and a deep dive into User Defined Reports.

Tags:

SQL Developer

VSCode

Heat map for Redo Size in SQL Developer...

Submitted by dave on Tue, 03/08/2016 - 11:23

I've gotten a lot of mileage out of my old SQL Developer Archive Log Count Heat Map report that I created in SQL Developer. I was recently asked to estimate the amount of redo that might be sent to a DataGuard standby. Searching The Google for this and I found some methods for calculating Network Bandwidth but I wanted to start with raw redo generated from an instance using information from v$archived_log.

Tags:

5 in 5 Vizualization 2 - Generating a d3.js visualization from a SQL Developer HTML report...

Submitted by dave on Fri, 03/06/2015 - 12:20

This second vizualization is more of a workflow proof of concept compared to some novel visualization but I can guarantee you haven't seen the SCOTT.EMP table like this before. I have wanted to combine my two favorite tools for a while. Here is how you can drive a d3.js visualization directly from a SQL Developer custom report.

Tags:

SQL Developer 4 User Defined Reports

Submitted by dave on Thu, 03/05/2015 - 11:26

I enjoyed giving my presentation on SQL Developer User Defined Reports to the 2014 East Coast Oracle Users Conference. This is a local conference that is a great value and pulls in lots of fun folks that attend and present.

DMann-SQLDeveloper4Reporting.pdf

Check out my GitHub project for examples and source code : https://github.com/dmann99/SQLDevUDRepPack

Tags:

SQL Developer

D3.JS

reports

Updated Heat Map Report

Submitted by dave on Wed, 10/24/2012 - 23:50

During my preparation for a visualization presentation at East Coast Oracle Users Group I realized I had an opportunity for a teaching moment on Levels of Abstraction. A few months back I published my PL/SQL code for an Archived Log Switch Heat Map.

Tags:

SQL Developer

pl/sql

visualization

Using Google Charts API and SQL Developer (or SQLPLUS)...

Submitted by dave on Mon, 07/30/2012 - 13:02

I added a page to my SQL Developer Tips and Tricks page about integrating the Google Graph API with SQL Developer HTML reports.

I sometimes run out of steam with the built in chart and gauge capabilities of SQL Developer. With a little work you can leverage the Google Graph API to create Line, Bar, Pie Charts, Map, Scatter, Venn Diagrams, Radar Charts, QR Codes and Meters.

Here is everything you need to know to get started: SQL Developer and Google Graph API Example

-Dave

Tags:

SQL Developer

pl/sql

Google Chart

Archived Log Switch Heat Map for SQL Developer...

Submitted by dave on Tue, 07/24/2012 - 12:01

... or just use SQLPLUS to spool to HTML and open with a browser if you are old school :)

I am on week 4 of my newly reimaged work laptop sans Toad. I am trying to make a go of things with SQL Developer only. So far so good. I have a more comprehensive post on my transition in the works but in the meantime I have been filling in some gaps with User Defined Reports. I started collecting them here: https://github.com/dmann99/SQLDevUDRepPack

Tags:

SQL Developer

pl/sql

Speed up SQL Developer Startup

Submitted by dave on Mon, 11/14/2011 - 15:23

If you are using SQL Developer 2.x you can reduce your startup time by about 20% by disabling any unneeded extensions. I was able to reduce my startup time from 11 seconds to 8 seconds by turning off all extensions (none of which I really needed anyway).

Tags:

performance

SQL Developer

Using Proxy Connections with SQL Developer or SQLPLUS

Submitted by dave on Tue, 09/13/2011 - 15:04

When trying to debug for another user sometimes it is helpful to be able to log in as that user. In the past magic was done by admins by storing the encrypted passwords, setting to a new temporary password, logging in, and then resetting the old encrypted password back.

Luckily modern Oracle versions we have the concept of a Proxy user. This allows connecting as one user but masquerading as another user (once proper permissions have been granted of course).

So far I have done this with SQL Developer and SQLPLUS, instructions are below for a test case.

Tags:

sqlplus

SQL Developer

Proxy