answersLogoWhite

0

Database Buffer cache is one of the most important components of System Global Area (SGA). Database Buffer Cache is the place where data blocks are copied from datafiles to perform SQL operations.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

Is Buffer cache is hardware entity?

I think No. Because buffer cache is a part of kernel and kernel is a software entity thats why buffer cache is also a software entity. However the buffer and the cache both are hardware entity separatly.


What are difference between cache database and sql database?

CACHE is multidimensional and postconsonantal database and its supporting scripting


What is a buffer called when it is reading a ram or a drive?

Cache


What difference between 32MB cache buffer and 64MB cache buffer?

A megabyte is a unit of information storage equal to 8,388,608 bits. The cache buffer is an area of extremely fast-access memory used by the processor, so the larger the area, the more data could take advantage of this speed. The "difference" between the two is self-evident.


What type of information is kept on a database?

All types of information may be kept in a database.


Why are caches useful?

To improve your speed to have a lot of respect, not to upgrade hardware is good program, such as optimizing application performance, database depots table, one separation, reading and writing separation, deployment WangDa range of local CDN (also can use own multiple sites data center speed), and many, many cache usage. Cache also divides a lot of kinds, PHP code for a cache, data buffer, the browser and the browser cache.


What is an oracle instance?

Instance is a combination of memory structure and process structure. Memory structure is SGA and Process structure is background processes. SGA - System or Shared Global Area. Components of SGA:- DBBC - Database Buffer Cache SP - Shared Pool. It is futher divided into Library Cache(LC) and Data Dictionary Cache(DDC) or Row Cache. RLB - Redolog Buffer Background Process:- 1. Mandatory Processes- a. SMON - System Monitor b. PMON - Process Monitor c. DBWR - Database writer d. LGWR - Log Writer e. CKPT - Check point f. RECO - Recoverer 2. Optional Process:- a. ARCN b. RBAC c. MMAN d. MMON e. MMNL


Use the word cache in a sentence?

He kept a large cache of papers in his locker.yes i can, here it is, Can u use the french word cache in a sentence?


What does the cache(8 meg) mean or do for a for a hard drive?

The cache size is refers to the size of buffer on the hard drive. The bigger the the buffer, the less the hard drive has to access the drive. Also it improves the time that the computer needs to access data from the drive.


What is SGA in orcle?

SGA is used to store the database information that is shared by database processes. It contains the data and control information of the oracle server and it is allocated in the virtual memory of the computer where oracle resides. By, Srinivasan Thirunavukkarasu.


What are the advantages and diadvantages of a buffer cache?

A cache allows one to retrieve commonly used information very quickly (if it is still in the cache) rather than trying to find it on the system (which takes much longer). The disadvantage is that is takes away memory from the system to implement the cache.


What do you call the memory in an input or output device?

Typically Storage. But it can also be called Cache, Buffer, or RAM