Snapshot progress monitor 8.1.7.3

From: Michael Spellbrink <michaelspellbrink_at_yahoo.de>
Date: 26 Aug 2003 09:01:19 -0700
Message-ID: <638121fa.0308260801.62a8086a@posting.google.com>

i have a hard time to get something like a snapshot progress bar using plsql in Oracle 8.1.7

i want to know how long a snapshot that currently refreshes (refresh mode is fast) will take until it is finished and the transaction finally commits.
therefore, i queried v$transaction and sys.v_$rollstat (and sys.v_$rollname )
and looking at the results, i see the rollback segment growing. but, where do i get the max values for the transaction? i thought that the mlog$_ tables might contain something that helps, but the sum
of the change vectors does not seem to correlate with the size of the rollback segment.
there is no need to get 100% exact values, it would be suitable to get only estimated values.

thanks in advance,

michael spellbrink Received on Tue Aug 26 2003 - 11:01:19 CDT