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.

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

2 Answers   Zenith,

---

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.

0 Answers   Infosys,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

Explain materialized views and how they are used.

0 Answers  

---

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  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

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

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---