Re: DROP LMT TBS internals.

Check in V$Session_longops ... See if an Entrys Being Mae there ...

Also See v$session_wait to see what the session's wait is showing ....

HTH ~Ganesh

On Sun, 19 Sep 2004 10:20:50 +0300, sjhussain_at_alfransi.com.sa <sjhussain_at_alfransi.com.sa> wrote:
>
>
> Hello List,
>
> If I am dropping a LMT Tablespace and it takes a long time, how can I know
> that the process is running, not hanged. Can anyone let me know what are
> the internal functionality of drop tablespace. I know that we can check
> fet$ for DMT TBS, how about LMT TBS?
>
> Best Regards,
>
> Syed Jaffar Hussain
>
> Visit us on www.alfransi.com.sa
> ====== Banque Saudi Fransi - Privacy Notice ======
> This message is intended only for the person or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> use of this information by persons or entities other than the intended
> recipient is prohibited. If you have received this in error, please
> contact the sender and delete the material from your computer. Any
> opinions and other information contained in this message that do not
> relate to the official business of Banque Saudi Fransi shall be
> understood as neither given or endorsed by it. Although precautions
> have been taken to ensure no viruses are present in this email, BSF
> cannot accept responsibility for any loss or damage arising from the
> use of this email or attachments.
> ====== Banque Saudi Fransi - Privacy Notice ======
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l