How many memory layers are in the shared pool?
Answer / 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 |
What is self-referential integrity constraint ?
Is java required for oracle client?
What are the limitations oracle database 10g xe?
What are the built-in functions used for sending Parameters to forms ?
what happened to the global index when I truncate the data in one of the partition?
what is the difference between substr and instr function in oracle?
What is the database name in oracle?
What is a cluster Key ?
What are Schema Objects ?
In what script is snap$ created? In what script is the scott/tiger schema created?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
how to get the second max val for every group in a table