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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
