Answer / santosh kumar

1.Threads share the address space of the process that created it; processes have their own address.

2.Threads have direct access to the data segment of its process; processes have their own copy of the data segment of the parent process.

3.Threads can directly communicate with other threads of its process; processes must use interprocess communication to communicate with sibling processes.

4.Threads have almost no overhead; processes have considerable overhead.

5.New threads are easily created; new processes require duplication of the parent process.

6.Threads can exercise considerable control over threads of the same process; processes can only exercise control over child processes.

7.Changes to the main thread (cancellation, priority change, etc.) may affect the behavior of the other threads of the process; changes to the parent process does not affect child processes.

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1 Answers  

---

what is a user-defined lock?

1 Answers   Oracle,

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

What is checkpoint?

3 Answers   Accenture,

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

how can you find out if a table can be redefined?

1 Answers   Oracle,

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1 Answers   Infosys,

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---