Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> table reorg

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US