Index Block Splits
845641May 10 2012 — edited May 10 2012How we can reduce or tune index block splits.. I mean wait event for leaf node splits, a session might be waiting to read the block which is getting split. And i guess index block split is natural we cannot avoid it, like for example ginger value has to be inserted between finger and hello, so to insert ginger value oracle will split the block into 2 by inserting ginger and moving hello to another block.. please help me or explain me experts