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 can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---