Answer / diksha

select count(*) from v$session where username like ''

Answer / kishore

select count(*),username from v$session where group by username;

Answer / braj123

select count(*) from v$session where user_name="**";

Can we take incremental backups in datapump?

1 Answers  

---

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  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

---

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

4 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 switch from an init.ora file to a spfile?

4 Answers   TCS,

---

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 difference between hot backup n rman backup?

1 Answers   Value Labs,

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

Oracle 11g new features?

2 Answers  

---