or you could check v$session_waits and look the wait events
f_vari_at_libero.it (fabio) wrote in message news:<60e08057.0205192350.332a0a47_at_posting.google.com>...
> "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 Tue May 21 2002 - 17:16:15 CDT
