RE: how to monitor the progress of inserts

  • From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
  • To: 'Niall Litchfield' <niall.litchfield@xxxxxxxxx>, "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
  • Date: Tue, 1 Feb 2005 11:39:16 -0500

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: