Index rebuild online lock issue

From: John D Parker <orclwzrd_at_yahoo.com>
Date: Wed, 2 Apr 2008 12:15:55 -0700 (PDT)
Message-ID: <569909.90673.qm@web32608.mail.mud.yahoo.com>

Ok, I know that at the end of alter index rebuild online, a lock is taken while the index that has been built is synchronized with the current state of the world as we know it. My question is this. How does one measure/monitor this lock? I know that on a normal "small" index, this lock is almost undetectable. However, on a 4TB OLTP system with a 95GB index on a 384GB table is not small nor will the sync to current state be undetectable. How does one measure/monitor this lock?

Thanks for any ideas or assistance!
John        

---

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 02 2008 - 14:15:55 CDT