Answer / Jitendra Kumar Singh

Information about active sessions in an Oracle database can be recorded using the V$SESSION view. This view provides detailed data about each session, including its status, username, SQL ID, and other relevant information.

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

how can a session indicate its interest in receiving alerts?

1 Answers   Oracle,

---

What is transparent data encryption? : sql server DBA

1 Answers  

---

How many memory layers are in the shared pool?

3 Answers  

---

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

4 Answers   Wipro,

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

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?

1 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---