Shared pool

Hi,
How is the data written into Library cache and Dictionary cache ?
Is it the server process ???

Quote:

---

Originally posted by bang_dba
Hi,
How is the data written into Library cache and Dictionary cache ?
Is it the server process ???

---

It's not the data that is written to Library Cache, it's the parsed SQL, procs, etc. Data are written to Buffer Cache.

Yes, server processes does that.

Dict cache contains Data dictionary information cached from the Data dictionary tables. Which is loaded when the details required to parse/execute the query from Disk(Dict tables) to Memory(Dict cache)