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@xxxxxxxxx> 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

Other related posts: