What Are Database Buffers?

1.	What Are Database Buffers?
Answer» It is the portion of the System GLOBAL AREA that holds copies of data blocks read from datafiles. All user PROCESSES are connected to the instance CONCURRENTLY and share access to the DATABASE buffer cache. It is the portion of the System Global Area that holds copies of data blocks read from datafiles. All user processes are connected to the instance concurrently and share access to the database buffer cache.

Answer»

It is the portion of the System GLOBAL AREA that holds copies of data blocks read from datafiles. All user PROCESSES are connected to the instance CONCURRENTLY and share access to the DATABASE buffer cache.

It is the portion of the System Global Area that holds copies of data blocks read from datafiles. All user processes are connected to the instance concurrently and share access to the database buffer cache.

Discussion

No Comment Found

Related InterviewSolutions

How Do You Use A Pointer To A Function?
What Is Size Of Void Pointer?
Write A C Program To Find Size Of Structure Without Using Sizeof Operator?
What Is The Meaning Of Prototype Of A Function?
What Is Wild Pointer In C?
What Is Dangling Pointer In C?
Write A C Program To Swap Two Variables Without Using Third Variable ?
In C, What Is The Difference Between A Static Variable And Global Variable?
Is Using Exit() The Same As Using Return?
Why Does Pascal Matter? Is There Any Benefit To Using Pascal Functions?

What Are Database Buffers?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment