December 2002
Intermediate to advanced
928 pages
85h 29m
English
The shared pool caches various constructs that can be shared among users. For example, SQL statements issued by users are cached so that they can be reused if the same statement is submitted again. Another example is stored procedures— pieces of code stored and executed within the database. These are loaded into the shared pool for execution and then cached, again using an LRU algorithm. The shared pool is also used for caching information from the Oracle data dictionary, which is the metadata (or data describing data structures) that describes the structure and content of the database itself.