Monitor Data Loads using SQL Developer Gauges

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.