Monitor the values in USED_UBLK and USED_UREC in V$TRANSACTION (i.e. number of undo blocks and undo records used by the transaction); I believe USED_UREC comes pretty darn close to tracking the number of extents. Close enough, anyway... You can get to V$TRANSACTION from V$SESSION by joining V$SESSION.TADDR to V$TRANSACTION.ADDR. Hope this helps... on 5/5/04 3:28 PM, Adams, Matthew (GE Consumer & Industrial) at MATT.ADAMS@xxxxxx wrote: > I'm truncating a table with around 14,000 extents > on a 7.3.4 database on a slow machine. > (Please don't ask how this happened, it's too=20 > painful to re-live.) > > Is there anyway to determine how far the truncate > has gotten at any given point? I thought I might see > changes in sys.fet$ or sys.uet$ as extents are de-allocated, > but I'm not seeing that. > > > > ---- > Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx > Just once, I wish we would encounter an > alien menace that wasn't immune to bullets.=20 > - The Brigadier > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------