Re: Index rebuild online lock issue
Date: Thu, 3 Apr 2008 11:20:10 -0700 (PDT)
Message-ID: <597063.19103.qm@web80608.mail.mud.yahoo.com>
John, to "measure and monitor", isn't it just a matter of checking v$lock?
Also, you can check what locks are taken during the entire process of
rebuilding an index by setting event 10704 at level 10 in your session. The
trace file should tell you.
Yong Huang
> From: John D Parker <orclwzrd_at_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://tc.deals.yahoo.com/tc/blockbuster/text5.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 03 2008 - 13:20:10 CDT