The background processes interact with the operating system and each other to manage the memory structures for the instance.
These processes also manage the actual database on disk and perform general housekeeping for the instance.
Figure 3-10 illustrates the memory structures and background processes discussed in the following section.
Here are some terms from this module that may have been new to you:
- pinning packages: The process of keeping packages inside the library cache
- estat-bstat utility: Oracle begin statistics (utlbstat.sql) and end statistics (utlestat.sql). These are used to create an elapsed-time snapshot of Oracle activity.
- shared SQL area: The shared SQL area is used to keep and process SQL statements and PL/SQL code.
- library cache miss ratio: Represents the ratio of the sum of library cache reloads to the sum of pins.
In the next module, we will look at tuning the Oracle buffer cache.