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 ====== > > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l