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@xxxxxxxxxxxxxxx
<sjhussain@xxxxxxxxxxxxxxx> 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

Other related posts: