Hi Vadim,
Are your inserts doing 'INSERT /*+ APPEND */'?
Append implies an exclusive, rather than shared lock.
-Mark
On Wed, Sep 28, 2016 at 4:36 PM, Vadim Keylis <vkeylis2009@xxxxxxxxx> wrote:
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
