Re: monitor a drop tablespace

select file#,count(*) from sys.fet$
 where ts#=??? group by ts#,file#

find your ts# from v$tablespace, you can see whether your database is working on delete from fet$. If the count(*) is not changing for a few minutes, then it is clear that your database is hung, if it is decreasing, you know you have tooooo many extents in that tablespace.....

hope it helps.
"fabio" <f_vari_at_libero.it> wrote in message news:60e08057.0205191035.7980a308_at_posting.google.com...
> hi,
> i'm dropping a 800Gb's tablespace
> How can i monitor this session.
> It work from 4 Hours and i don't know how many time it spent againg
>
> Someone can help me???
>
>
> thanks
>
>
> P.S. Sorry for my english
>
>
> bye Fabio
Received on Sun May 19 2002 - 16:44:51 CDT