Tuesday, February 23, 2016

Shared Buffers

Shared Buffers is the area needed for the Query Processing.

Shared Buffers are needed to ensure that the server processes handling user queries, never need to wait for a write to occur.

Buffer being modified is called a Dirty Buffer.

Any Query connecting to the Database requires a buffer area to process the User Request.

Shared Buffers is the memory area that gives the buffer place to Queries connecting to the Database.

Data from the Database’s Data files is fetched to the Memory.

No comments:

Post a Comment