table reorg
- From: raja rao <raja4list@xxxxxxxxx>
- To: oracle list <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 6 May 2006 07:46:40 -0700 (PDT)
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.
Other related posts:
