Answer / santosh

You can use v$session and v$locks to view this. If you want
to see which process is taking long time you can query
v$session_longops

Answer / santo

Query v$sesstat or v$waitstat views.

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

0 Answers  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

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  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

how can you schedule a job in database?

0 Answers   Oracle,

---

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

4 Answers   Wipro,

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

How can we see the database version in os level

6 Answers   Oracle,

---

How would you force a log switch?

4 Answers  

---