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 |
How you open and close a cursor variable.Why it is required?
What is a schema in oracle?
What are different Oracle database objects?
How to get a list of all background sessions in the database?
Explain drop constraint oracle?
what are bitmap indexes? How does they work?
What is proxy method?
What are the various oracle database objects?
What is the implicit cursor in oracle?
What are various joins used while writing SUBQUERIES?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
How to check your oracle database 10g xe installation?