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.