How many memory layers are in the shared pool?
- 1 Answers
- 4549 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 is a user account in oracle?
Can we create trigger on view in oracle?
How to turn on or off recycle bin for the instance?
What is a dynamic performance view in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is system global area (sga) in oracle?
what is the difference between sql& oracle?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
How to get a list of all background sessions in the database?
What is different types of joins?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
How to install oracle odbc drivers?
Oracle General 
