INSERT statement hangs due to library cache lock
From: Vadim Keylis <vkeylis2009_at_gmail.com>
Date: Wed, 28 Sep 2016 13:36:10 -0700
Message-ID: <CAHL4c1M2NDZsZTnnvxDxtNwOaHNumXx6zrF6pQqzEn_sv65iVA_at_mail.gmail.com>
Good afternoon. We have partition table that is partition by day with two local indexes. One index non unique the other is unique, but both indexes are local to a partition. We never dropped partitions since table was created in 2012. We were dropping all partition through 9/24. Looking at the Enterprise Manager Cloud Control we observed the spike in insert statements into that table. The spike was caused by library cache lock. None of the insert statements would go into partitions we were dropping. Will appreciate an advise why dropping partition would cause library cache lock on the table?
Date: Wed, 28 Sep 2016 13:36:10 -0700
Message-ID: <CAHL4c1M2NDZsZTnnvxDxtNwOaHNumXx6zrF6pQqzEn_sv65iVA_at_mail.gmail.com>
Good afternoon. We have partition table that is partition by day with two local indexes. One index non unique the other is unique, but both indexes are local to a partition. We never dropped partitions since table was created in 2012. We were dropping all partition through 9/24. Looking at the Enterprise Manager Cloud Control we observed the spike in insert statements into that table. The spike was caused by library cache lock. None of the insert statements would go into partitions we were dropping. Will appreciate an advise why dropping partition would cause library cache lock on the table?
Thanks so much in advance,
Vadim
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 28 2016 - 22:36:10 CEST