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.

Datapump backup steps?

1 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

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?

0 Answers  

---

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

0 Answers  

---

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

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---