Answer Posted / md mubeen
Shared pool buffers cache consists of two layer
1)Library cache (LC) 2) Data dictionary cache (DDC)
in the Library cache the parsed information data will be
stored 2)DDC contains the dictionary tables which stores
the meta data information .
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is key preserved table?
How to select some columns from a table in oracle?
What is a partition in oracle?
What is an oracle function?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What are the set operators union, union all, minus & intersect meant to do?
What is Java Pool in Oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Is it possible to insert comments into sql statements return in the data model editor ?
What is a dead lock in oracle?
What is a nested table and how is it different from a normal table?
Can I create users through internet explorer in oracle 10g?
Is the After report trigger fired if the report execution fails ?
What are the varoius components of physical database structure of oracle database?
How to get execution statistics reports on query statements?