How many memory layers are in the shared pool?
- 1 Answers
- 4229 Views
- I also Faced
- E-Mail Answers
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 extensions used by oracle reports?
What is ordinary table in oracle?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
How does oracle handle read consistency?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
what is the difference between restoring and recovering?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
How to speed up webrick?
Explain how are indexes update?
How to create a server parameter file?
Can a primary key contain more than one columns?
What does a Control file Contain ?
Oracle General 
