db file scattered read

創(chuàng)新互聯(lián)專注于企業(yè)成都全網(wǎng)營(yíng)銷、網(wǎng)站重做改版、營(yíng)口網(wǎng)站定制設(shè)計(jì)、自適應(yīng)品牌網(wǎng)站建設(shè)、H5技術(shù)、成都做商城網(wǎng)站、集團(tuán)公司官網(wǎng)建設(shè)、外貿(mào)網(wǎng)站建設(shè)、高端網(wǎng)站制作、響應(yīng)式網(wǎng)頁(yè)設(shè)計(jì)等建站業(yè)務(wù)，價(jià)格優(yōu)惠性價(jià)比高，為營(yíng)口等各大城市提供網(wǎng)站開發(fā)制作服務(wù)。

官網(wǎng)解釋：

This event signifies that the user process is reading buffers into the SGA buffer cache and is waiting for a physical I/Ocall to return. A db file scattered read issues a scattered read to read the data into multiple discontinuous memory locations. A scattered read is usually a multiblock read. It can occur for a fast full scan (of an index) in addition to a full table scan.

The db file scattered read wait event identifies that a full scan is occurring. When performing a full scan into the buffer cache, the blocks read are read into memory locations that are not physically adjacent to each other. Such reads are called scattered read calls, because the blocks are scattered throughout memory. This is why the corresponding wait event is called 'db file scattered read'. multiblock (up to DB_FILE_MULTIBLOCK_READ_COUNT blocks) reads due to full scans into the buffer cache show up as waits for 'db file scattered read'.

Check the following V$SESSION_WAIT parameter columns:

• P1: The absolute file number

• P2: The block being read

• P3: The number of blocks (should be greater than 1)

on a healthy system, physical read waits should be the biggest waits after the idle waits. However, also consider whether there are direct read waits (signifying full table scans with parallel query) or db file scattered read waits on an operational (OLTP) system that should be doing small indexed accesses.

Other things that could indicate excessive I/O load on the system include the following:

• Poor buffer cache hit ratio

• These wait events accruing most of the wait time for a user experiencing poor response time

解釋：db file scattered read 等待事件：是由于多數(shù)據(jù)塊讀操作產(chǎn)生的，當(dāng)我們檢索數(shù)據(jù)時(shí)從磁盤上讀取數(shù)據(jù)到內(nèi)存中，一次I/0讀取多個(gè)數(shù)據(jù)塊，而數(shù)據(jù)塊在內(nèi)存中是分散分布并不是連續(xù)的，當(dāng)數(shù)據(jù)塊讀取到內(nèi)存中的這個(gè)過(guò)程就會(huì)產(chǎn)生“db file scattered read” 事件。

    多個(gè)數(shù)據(jù)塊讀場(chǎng)景：

      （1） FTS（Full Table Scans) 全表掃描

      （2） IFFS（Index Fast Full Scans) 索引快速全掃描： 把索引鏈切割成很多份，多塊并行讀取。

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。

新聞標(biāo)題：Oracle等待事件之dbfilescatteredread-創(chuàng)新互聯(lián)
文章來(lái)源：http://weahome.cn/article/doedep.html