While trying to find an index key in an index block, Oracle noticed that the index block was being split. Oracle will wait for the split to finish and try to find the key again.
Wait Time: The session will yield the CPU, so there is no actual waiting time
| Parameter | Description |
|---|---|
|
rootdba |
The root of the index |
|
level |
This is the level of the block that the session is trying to split in the index. The leaf blocks are level 0. If the level is > 0, it is a branch block. (The root block can be considered a special branch block). |
|
childdba |
The block that the session is trying to split |
See Also:
Oracle Database Performance Tuning Guide for more information about index block splits