Buffer busy waits in Oracle
Posted by satish on Mar 22, 2019; 4:06pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Buffer-busy-waits-in-Oracle-tp7309.html
Hi erman,
I have asked this question to few blogs but did nt get satisfied response.I hope,i will get it here and Here is my concern
When multiple sessions are requesting the blocks that reside in the disk, it takes too much time for a session to read it into the buffer cache. Other session(s) that need the same block will register ‘buffer busy wait’.
Is this true?If yes, I would like to understand why it takes too much time to read into the buffer cache?
Appreciate your efforts