From the course: Oracle Database 12c: Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Redo log buffer

Redo log buffer - Oracle Database Tutorial

From the course: Oracle Database 12c: Administration

Start my 1-month free trial

Redo log buffer

- [Narrator] Are we having fun exploring the Oracle Instance? Remember, we have an Oracle Instance; inside it, we have an SGA component which groups various types of in-memory caches that Oracle uses; each one of those in-memory caches is used to store different information for greater performance. Now, it's time to move to the RedoLog Buffer; another essential component of the SGA. The RedoLog Buffer is a circular buffer that stores information pertaining to changes made to the database; whoa, whoa, whoa, hold on. Didn't I just say that the buffer cache and the shared pool are the ones used to cache database data and metadata respectively? Why do we need another in-memory cache for database changes? Well, the answer is that the RedoLog Buffer is specifically designed to store something known as redo entries. Redo entries are small records that reflect any changes made to the database as part of transactions or database structure changes, also known as DML; data modification language…

Contents