Re: DROP LMT TBS internals.

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: sjhussain@xxxxxxxxxxxxxxx
  • Date: Sun, 19 Sep 2004 09:34:17 +0100

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 ....



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
> ======  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  ======
> --

Other related posts: