Answer / chandra mohan

LIBRARY CACHE,DATA DICTIONARY CACHE

Answer / sweta

Hi,
in shared pool 2 memory layers are there,
they are,
library cache(to get the recentrly executed sql and pl/sql
statements) and data dictionary cache(to store the sql and
plsql statements and execution path of sql/plsql statemens
i.e explain paln of it) cursor sharing information etc.

Answer / narmada kumari

1/3 of physical memory, can be 2/4k depending on bit of 32 or 64

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

What is checkpoint?

3 Answers   Accenture,

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

why we use cursors

1 Answers  

---