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

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

what is grd?

0 Answers   Oracle,

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

How would you force a log switch?

4 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

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

0 Answers  

---