Oracle Database Discussions

Buffer busy wait - when one session is accessing a block from the buffer, other session which needs to access the same block has to wait till the first session completes reading.
This means until the first session completes reading the block no other session can access the same block, it has to wait.

Initrans - If it 4, means that 4 sessions can update the same block simultaneously(different rows though).

Could any one please explain me how it is possible to update the same block simultaneously (as defined by inittrans) , considering the definition of buffer busy wait?Or is my understanding wrong? Please clarify.