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

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

What type of index should you use on a fact table?

1 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

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

1 Answers   Cap Gemini, iGate,

---

---

what is logical system in sap basis

0 Answers  

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

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  

---

How would you determine who has added a row to a table?

4 Answers  

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---