locking only needed Partitions when inserting.
In an highly write-intensive DB, we encounter many situations where one
We're going to great lengths to make sure we never read from a partition we write to, but it seems like insert (both insert select and insert values) lock the entire table, even though the could lock only the relevant partitions (the select have an explicit condition on the output, which can say what is the partition)...
Is there any easy way to avoid those locks?
Subject
Views
Written By
Posted
locking only needed Partitions when inserting.
2792
January 29, 2009 09:10AM
2372
February 03, 2009 02:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.