Answer / b.r.reddy

We can manually set the statistical values.
We can gather statistics in parallel mode.

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

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

1 Answers   CTS,

---

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

2 Answers  

---

what is ora 600?

1 Answers  

---

---

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

1 Answers  

---

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

0 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

what is the use of home directory???

1 Answers   HP,

---

how can you record information about current session?

0 Answers   Oracle,

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---