Re: monitor a drop tablespace

"charlie.peltier" <charlie.peltier(delete here-antispam)@verizon.net> wrote in message news:<n1VF8.533$F74.41_at_nwrddc02.gnilink.net>...
> 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

Thank all...

the TBS has benn droppen in ten Hours (Yes... 10h !!!!!) Thank to Charlie that help me so much.
With the fet$ table i can see that the DB is working. Received on Mon May 20 2002 - 02:50:00 CDT