Re: how to monitor the progress of inserts

And about 10g, this is what I talk about, and I repeat, I didn't tested this features, but based on documentation it could help, maybe.

And the monitoring feature in 10g is automatic when you set to typical the statistics level
STATISTICS_LEVEL=TYPICAL
Automatically Collecting Statistics on Tables

The PL/SQL package DBMS_STATS lets you generate and manage statistics for cost-based optimization. You can use this package to gather, modify, view, export, import, and delete statistics. You can also use this package to identify or name statistics that have been gathered.

Formerly, you enabled DBMS_STATS to automatically gather statistics for a table by specifying the MONITORING keyword in the CREATE (or ALTER) TABLE statement. Starting with Oracle Database 10g, the MONITORING and NOMONITORING keywords have been deprecated and statistics are collected automatically. If you do specify these keywords, they are ignored.

Monitoring tracks the approximate number of INSERT, UPDATE, and DELETE operations for the table since the last time statistics were gathered. Information about how many rows are affected is maintained in the SGA, until periodically (about every three hours) SMON incorporates the data into the data dictionary. This data dictionary information is made visible through the DBA_TAB_MODIFICATIONS,ALL_TAB_MODIFICATIONS, or USER_TAB_MODIFICATIONS views. The database uses these views to identify tables with stale statistics.

To disable monitoring of a table, set the STATISTICS_LEVEL initialization parameter to BASIC. Its default is TYPICAL, which enables automatic statistics collection. Automatic statistics collection and the DBMS_STATS package enable the optimizer to generate accurate execution plans.

On Tue, 1 Feb 2005 12:26:58 -0400, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
> 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.
>

-- 
Oracle 9i,10g Certified Professional
Experience on Orace 7,8i
Developer 6i Certified Professional

8 years of experience in Administration, developing and design
--
http://www.freelists.org/webpage/oracle-l