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 are the different types of synonyms?
How to pass a cursor variable to a procedure?
How to convert a date to char in oracle? Give one example.
What is the difference between sharding and partitioning?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
How to declare a local variable?
what are different types of locks?
What is the difference between an Oracle Schema and an Oracle Instance?
What is hash cluster in oracle?
How to select the name of employee who is getting maximum sal with out using subquery
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is pragma autonomous transaction in oracle?