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

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

0 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

what is grd?

0 Answers   Oracle,

---

how can you record information about current session?

0 Answers   Oracle,

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

How do you add a data file to a tablespace?

3 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

what is the use of home directory???

1 Answers   HP,

---