how can I see when it is being used?
Can I run a select distinct on a big table and then look somewhere as sys whilst that is running (equivelant place to dba_temp_files in 9i whatever it was in 8i)?