Oracle等待事件之dbfilescatteredread

db file scattered read

企業(yè)建站必須是能夠以充分展現(xiàn)企業(yè)形象為主要目的，是企業(yè)文化與產(chǎn)品對外擴展宣傳的重要窗口，一個合格的網(wǎng)站不僅僅能為公司帶來巨大的互聯(lián)網(wǎng)上的收集和信息發(fā)布平臺，創(chuàng)新互聯(lián)建站面向各種領(lǐng)域：成都食品包裝袋等成都網(wǎng)站設(shè)計、全網(wǎng)營銷推廣解決方案、網(wǎng)站設(shè)計等建站排名服務(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ù)據(jù)到內(nèi)存中，一次I/0讀取多個數(shù)據(jù)塊，而數(shù)據(jù)塊在內(nèi)存中是分散分布并不是連續(xù)的，當(dāng)數(shù)據(jù)塊讀取到內(nèi)存中的這個過程就會產(chǎn)生“db file scattered read” 事件。

    多個數(shù)據(jù)塊讀場景：

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

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

文章標題：Oracle等待事件之dbfilescatteredread
標題來源：http://muchs.cn/article38/ieppsp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供ChatGPT、用戶體驗、品牌網(wǎng)站制作、搜索引擎優(yōu)化、動態(tài)網(wǎng)站、網(wǎng)頁設(shè)計公司

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)

手機網(wǎng)站建設(shè)