Memory Architecture (contd)
Shared Pool : Contains dictionary cache and library cache.
- Dictionary Cache : Used for definition of tables, indexes, users, access rights, etc. to avoid accessing them frequently from SYSTEM table space.
- Library Cache : SQL code stored here. The code is parsed using the information in the dictionary cache; security is checked using current user’s privileges.
- Oracle optimizer prepares execution plan.