SQL Developer

Updated Heat Map Report

Submitted by dmann 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. Read more about Updated Heat Map Report

Tags:

SQL Developer

pl/sql

visualization

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

Submitted by dmann 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

Tags:

SQL Developer

pl/sql

Google Chart

dmann's blog

Archived Log Switch Heat Map for SQL Developer...

Submitted by dmann 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 Read more about Archived Log Switch Heat Map for SQL Developer...

Tags:

SQL Developer

pl/sql

Speed up SQL Developer Startup

Submitted by dmann 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). Read more about Speed up SQL Developer Startup

Tags:

performance

SQL Developer

Using Proxy Connections with SQL Developer or SQLPLUS

Submitted by dmann 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