Re: how to monitor the progress of inserts

From: Bruce McCartney <bruce.mccartney_at_dbinfosystems.com>
Date: Tue, 1 Feb 2005 09:47:13 -0700
Message-Id: <200502011646.j11Gkqok013697@mail93.megamailservers.com>

Juan,
I looked at using this feature. The data is not updated in 'real' time. I remember seeing something about the smon process updating the data supporting this feature asycronously. It is helpful- but can be misleading at a point in time...

Bruce

-----Original Message-----

From: "Juan Carlos Reyes Pacheco"<juancarlosreyesp_at_gmail.com> Sent: 2/1/05 9:26:58 AM
To: "niall.litchfield_at_gmail.com"<niall.litchfield_at_gmail.com> Cc: "Oracle-L (E-mail)"<oracle-l_at_freelists.org> Subject: Re: how to monitor the progress of inserts

Hi Niall, Based on documentation this could help her. But as I told, I didn't test this functionality, and I think this could need a COMMIT.

    MONITORING | NOMONITORING
    MONITORING Clause Specify MONITORING if you want Oracle to collect     modification statistics on table. These statistics are estimates of     the number of
    rows affected by DML statements over a particular period of time. They are     available for use by the optimizer or for analysis by the user.     --
    http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 01 2005 - 11:57:30 CST