Re: ALTER TABLE LOCK DISABLE

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Sat, 26 Mar 2005 02:13:44 +0530
Message-ID: <3b0f44a1050325124378e28fc@mail.gmail.com>

Larry:

I wouldn't subscribe to DISABLE TABLE LOCKS arguement as that posses a serious threat to HA operations. You can not re-build indexes or do any online table maintenence operations that requires table locking. It was even documented in Steve's internals book. But that is for OPS.

Now with significant enhancements in RAC, with faster messaging functions, I really do not see much performance improvement in disabling table locks. And also what percentage gain you get from disabling table locks is questionable..

--

Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 25 2005 - 15:47:30 CST