Elements of redo log buffer & Shared pool - Oracle Architecture

Q.  What are the elements of the redo log buffer and Shared pool?
- Published on 13 Aug 15

a. PGA
b. Buffer cache
c. Both a and b
d. SGA

ANSWER: SGA

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 26 Aug 15
    -The redo log buffer is a circular buffer in the SGA that holds information about changes made to the database. This information is stored in redo entries.

    -The shared pool portion of the SGA contains the library cache, the dictionary cache, the result cache, buffers for parallel execution messages, and control structures.

    -SGA - The System Global Area (SGA) is a group of shared memory areas that are dedicated to an Oracle instance (an instance is your database programs and RAM).

    -PGA - The Program Global Area (PGA) is a private memory region that contains the data and control information for a server process.
    -Only a server process can access the PGA.
    -Oracle Database reads and writes information in the PGA on behalf of the server process.

    -Buffer Cache - The database buffer cache is the portion of the SGA that holds copies of data blocks read from datafiles.
    -All users concurrently connected to the instance share access to the database buffer cache.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲