Oracle Database Discussions

Hi all,

I have a few doubts on Oracle Internals.

Shared pool contains Library Cache and Data Dictionary Cache.

Library Cache in turn contains Shared SQL Area and Shared PLSQL Area.

When executing a SQL statement

1. Where does the actual SQL statement text gets stored? Will it be stored in Shared SQL Area?


2. Where the parsed version of the statement will be? Will it be stored in Shared SQL Area?


3. What are all the information that will be stored in Data Dictionary Cache? If the table emp is used in USER

A's statement and USER B's Statement, then What are all the informaton that will be stored in Data Dictionary

Cache and how?

4. What is the role of Private SQL Area?

I went through all the oracle documentation from Oracle Site. But still not clear.


Please help me to understand the conceptw.


Regards,
Swaminathan