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. |  |
|
|
|
|
|
 |
Monitor Data Loads using SQL Developer Gaugesposted 2 Jan 2009 07:27 by Alan Nolan-Davies [ updated 22 Jul 2011 07:57 ] |