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

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

What is the default fill factor value? : sql server DBA

0 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

Datapump backup steps?

1 Answers  

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---