table reorg

From: raja rao <raja4list_at_yahoo.com>
Date: Sat, 6 May 2006 07:46:40 -0700 (PDT)
Message-ID: <20060506144640.38278.qmail@web31410.mail.mud.yahoo.com>

Hi All,    

  How to track the table reorg:    

  alter table xyz move;    

  A 2 GB table is taking long time to compelte the operation (almost we waited for 2 hrs, but no use).    

  Other tables more than 2 GB also taking little time ( ~ 15-20 mins).    

  can someone tell me how to track this and what could be the reason for this specific tbale taking long time for reorg ?        

  I checked for the wait events. No locks, no wait events.    

  is there a way to check the progress of this process ?    

  Thanks,
  Raj                 

---

Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.
--

http://www.freelists.org/webpage/oracle-l Received on Sat May 06 2006 - 09:46:40 CDT