Re: how to monitor the progress of inserts

How about --
SELECT OWNER, SUM(BYTES) FROM v$temp_extent_map GROUP BY OWNER ORDER BY 1;

Back before temporary TEMP tablespaces I used to use MAPPER.SQL to track the number of extents that the insert was using in the TEMP table. If I knew how much data I was trying to insert then I could tell how far along I was.

I'm not knowledgable enough to get MAPPER to work with temporary temp but v$temp_extent_map seems to supply the same info. User 0, I assume, means the extent is unused.

--
http://www.freelists.org/webpage/oracle-l