RE: how to monitor the progress of inserts

Niall, monitoring will show table as used, but statistics is updated 
at the time of commit. First, there is no statistics in USER_TABLES that
would count the number of times that blocks have been referenced by I/O
and second, statistics for monitored tables is not updated until the
transaction commits. To do otherwise would seriously break the relational
rules. Sadly, V$SESSION_LONGOPS is inaccurate, cryptic and, generally
speaking, useless. In everything else you and Juan are right.
Have a nice day.
Mladen Gogala
Ext. 121


Other related posts: