read by other session

今天dba组内讨论会议，在awr中top 5 events有read by other session：
首先还是看一看官方文档是怎么说的吧：
When information is requested from the database, Oracle will first read the data from disk into the database buffer cache.
If two or more sessions request the same information, the first session will read the data into the buffer cache while other sessions wait.
In previous versions, this wait was classified under the "buffer busy waits" event.
However, in Oracle 10.1 and higher, this wait time is now broken out into the "read by other session" wait event.
Excessive waits for this event are typically due to several processes repeatedly reading the same blocks,
e.g. many sessions scanning the same index or performing full table scans on the same table.
Tuning this issue is a matter of finding and eliminating this contention.
可以看出：是热点块的问题，以前该等待事件是归在buffer_busy_waits中，如果该等待事件严重的出现:
(1).buffer cache的大小不够，导致块从内存中交换出来；
（2）.sql问题，出现了对同一个索引进行大量的扫描或者对同一个表进行了全表扫描，表相同的block被重复的读取，这样就伴随着等待有db_file_scatter_read和db_file_sequence_read事件；

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11782778/viewspace-630965/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11782778/viewspace-630965/