Start of Content Area

Data Buffer (Oracle)  Locate the document in its SAP Library structure

Data buffers have the following functions:

Table: Data buffer and their functions

Buffer

Function

Data buffer

holds Oracle blocks in shared memory (System Global Area or SGA)

Data buffer quality
cache hit ratio (CHR)

measures the number of times that a data block requested by an Oracle process is found to be already in memory.

Physical reads and
physical writes

Information is also provided on the number of physical input/output (I/O) operations performed on behalf of Oracle

Busy waits

the number of times a process had to wait to acquire a data buffer in a compatible state

See also:

Monitoring the Data Buffer (Oracle)

Buffer Busy Waits (Oracle)

DB_BLOCK_BUFFERS (Oracle)