Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: monitor a drop tablespace

Re: monitor a drop tablespace

From: charlie.peltier <here-antispam)_at_verizon.net>
Date: Sun, 19 May 2002 21:44:51 GMT
Message-ID: <n1VF8.533$F74.41@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
Received on Sun May 19 2002 - 16:44:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US