Shared Pool is used for storing data which is to be shared among all users of DB.
It consists of the following components: -
a.Dictionary Cache(also called as Row Cache): -It is used to resolve table name,privileges,..etc
b.Library Cache: - Its has execution plans of recently executed SQL and PLSQL stmts in Shared SQL and PLSQL areas.
c.Control Structure (Locks and Latches)
It is sized by SHARED_POOL_SIZE parameter.
Size of Both the Cache depends on the shared pool size and memory is allocated internally.
No comments:
Post a Comment