Troubleshooting Complex Oracle Performance Problems Speaker Deck. The tx enqueue is the transaction enqueue (a.k.a. This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment.
Solutions (a) solution is to reorganize the index in a way to avoid the contention or hot spots. Global hash partition the indexii. This wait event shows one process waiting for another to complete an index block split.
