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="**";

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

what is the use of ocr?

1 Answers   Oracle,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

Datapump backup steps?

1 Answers  

---

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

1 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

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

2 Answers   IBM,

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

1 Answers  

---