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 is the use of home directory???

1 Answers   HP,

---

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

0 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

Can we take incremental backups in datapump?

1 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

What is checkpoint?

3 Answers   Accenture,

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---