Answer / braj123

1.By using statspack report find buffer busy wait events.

2.>select * from V$system_event where event like '%wait%';

3.>select * from v$waitstat;

Solutions:
* Identify and eliminate hot blocks from the application
via changing the PCTFREE and PCTUSED values to reduce the
number of rows per data block.
* Each instance has its own freelist groups.
* Increase the number of rollback segments.

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

0 Answers  

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

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

1 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

What is fill factor? : sql server DBA

0 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---