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.

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

4 Answers   DELL, TCS,

---

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,

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

---

---

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

0 Answers   Oracle,

---

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

0 Answers  

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---