Re: how to monitor the progress of inserts

On Tue, 1 Feb 2005 13:07:10 -0800 (PST), david wendelken <davewendelken_at_earthlink.net> wrote:
> Niall,
>
> Very nice explanatory script. Kudos.

Thanks, just a quick note - if using the time command to advance the clock artificially by a bit over 3 hours to 23:55 - try to make sure you don't spend 6 minutes checking that the mail reads correctly and generally faffing about - otherwise the reset of the time is inconveniently on the wrong day :(

to use on 9i you'd need to explicitly enable table monitoring - on 10g STATISTICS_LEVEL needs to be TYPICAL (which it probably will be).

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l