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
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 01 2005 - 11:49:42 CST
