now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

Name three advisory statistics you can collect.

1 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---