In this video, we'll explain the goal of the Redo Log Buffer which helps maintain data consistency after restarts and crashes
- [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 commands…and DDL; data definition language command.…
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Fundamentals: Core Conceptswith Adam Wilbert2h 14m Beginner
Relational Database Fundamentalswith Adam Wilbert2h 40m Beginner
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 58s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.