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.
Database writer - Oracle Database Tutorial
From the course: Oracle Database 12c: Administration
Database writer
- [Narrator] So far, we've talked about the SGA and PGA parts of the Oracle instance. The SGA and PGA are areas in memory used for caching various types of database data as well as database metadata. In addition to caching, the Oracle Instance also contain what are know to be the Oracle background processes. These are a bunch of dedicated server-side processes running in the background. And similarly to the way that different components of the SGA cache different types of data, similarly, different Oracle background processes have different functions. Functions such as writing database blocks to disk, writing redo entries to disk, making sure all of the database files on disk are synchronized, and others. The background processes perform maintenance tasks required to operate the database and maximize performance for multiple users. This is why each background process handles a different task. So, are you ready to get to know this background processes? If so, let's dive right in. Take…
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.