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.

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

2 Answers   Satyam,

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

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

2 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

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

1 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

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

1 Answers  

---

internal architecture

0 Answers   CSC,

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

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

1 Answers  

---