]]>By: weihttps://jonathanlewis.wordpress.com/2014/03/13/shrink-space/#comment-64107
Fri, 21 Mar 2014 08:04:31 +0000http://jonathanlewis.wordpress.com/?p=12776#comment-64107> If you’re going to try to use multiple sessions to shrink several indexes as quickly as possible, make sure there’s no way that two sessions can try to “shrink space” on a single table concurrently.

And (agreeing) regarding “Oracle resolves deadlocks automatically,” it would be far better for folks trying to convey what Oracle does about deadlocks to start such claims with “Oracle breaks deadlocks automatically.”

Then perhaps it would be easier to get people to take seriously exactly the state of the youngest lock holder’s session, resolution of which has become the application’s province after Oracle has intervened to break the deadlock.

Here’s hoping the bit of this application (Oracle RDBMS) that needs to avoid or handle that deadlock is well contained enough that it can be fixed and back ported quickly and reliably!