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 - Oracle Database Tutorial
From the course: Oracle Database 12c: Administration
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.