Term
|
Definition
| Caches the most recently used SQL statements that have been issued by database users. |
|
|
Term
|
Definition
| Caches the data that has been most recently accessed by database users. |
|
|
Term
|
Definition
| Stores transaction information for recovery purposes. |
|
|
Term
|
Definition
| Caches the most recently used Java objects and application code when Oracle's JVM option is used. |
|
|
Term
|
Definition
| Caches data for large operations such as Recovery Manager (RMAN) backup and restore activities and Share Server components. |
|
|
Term
|
Definition
| Caches the data associated with queued message requests when Oracle's Advanced Queueing option is used. |
|
|
Term
|
Definition
| New in 12c, stores results of SQL queries and PL/SQL functions for better performance. |
|
|
Term
|
Definition
| Flash storage is used for additional buffer cache. |
|
|
Term
|
Definition
| Contains shared SQL Areas, private SQL areas, plsql programs and control structures and handles for this structure. |
|
|
Term
|
Definition
| Maintains recently executed SQL Statements and their execution plans. |
|
|
Term
| Data Dictionary Cache / row cache |
|
Definition
| Holds the most recently used database dictionary information. Known by two names. |
|
|
Term
| PL/SQL function result cache |
|
Definition
| Holds SQL and plsql function results. |
|
|
Term
|
Definition
| Area in the shared pool used to allocate large chunks of memory. |
|
|
