Monitor Data Loads using SQL Developer Gauges

posted 2 Jan 2009, 07:27 by Alan Nolan-Davies   [ updated 22 Jul 2011, 07:57 ]
How many times have you sat running select count(*) queries to see how your database loads are progressing.

Using SQL Developer you can put this in a Database Chart called a Gauge and set this to refresh as often as the drop down allows.

The chart on this page is just the query

select count(*) "ICE_CONTACTLOG"
from ice_contactlog

Then I set the Max value in the Gauge Details to the expected size when fully loaded

Then I can just leave this running in a corner of the screen to monitor Load Progress.