Answer / jeby sebastian

Memory area of oracle which consists of Library cache
(recently executed sql and pl/sql statements) and Data
Dictionary cache(recently used tables and indexes).

Answer / shaikh asif

IT IS A MEMORY STRUCTURE WHICH CONTAINS
1.)LIBRARY CACHE(HOLDS RECENTLY EXECUTED PL/SQL COMMANDS)
2.)DATA DICTIONARY CACHE(HOLDS ALL RECENTLY EXECUTED DDL
COMMANDS);

Answer / ravi dutta

shared pool contains both the data dictionary and the
library cache which are used for checking the syntax and the
execution plan respectively.

What are the two types of Server Configurations?

3 Answers  

---

How free extents are managed in Ver 6.0 and Ver 7.0 ?

1 Answers   IBM,

---

What is hit ratio ?

13 Answers   Indiabulls, RGPV,

---

What is meant by Redo Log file mirrorring ? How it can be achieved?

1 Answers  

---

When does LGWR write to the database?

3 Answers  

---

Which parameter in Storage clause will reduce no. of rows per block?

1 Answers  

---

What is the maximum size of a row in oracle 9i?

4 Answers   Baidu, HCL, Yashu Systems,

---

How to find the current session sid

3 Answers   Baidu,

---

How does Space allocation table place within a block ?

1 Answers  

---

What is a Rollback segment entry ?

3 Answers   TCS,

---

How will you estimate the space required by a non-clustered tables?

2 Answers  

---

How will you force database to use particular rollback segment?

1 Answers  

---