db file scattered read

企業(yè)建站必須是能夠以充分展現(xiàn)企業(yè)形象為主要目的，是企業(yè)文化與產品對外擴展宣傳的重要窗口，一個合格的網站不僅僅能為公司帶來巨大的互聯(lián)網上的收集和信息發(fā)布平臺，創(chuàng)新互聯(lián)建站面向各種領域：成都食品包裝袋等成都網站設計、全網營銷推廣解決方案、網站設計等建站排名服務。

官網解釋：

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ù)塊讀操作產生的，當我們檢索數(shù)據(jù)時從磁盤上讀取數(shù)據(jù)到內存中，一次I/0讀取多個數(shù)據(jù)塊，而數(shù)據(jù)塊在內存中是分散分布并不是連續(xù)的，當數(shù)據(jù)塊讀取到內存中的這個過程就會產生“db file scattered read” 事件。

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

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

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

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

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

廣告

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