Answer Posted / 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.

Why would you use sql agent? : sql server DBA

1083

---

what is grd?

1096

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1111

---

What is the default port no on which sql server listens? : sql server DBA

1162

---

What are the recovery models for a database? : sql server DBA

1132

---

What is replication? : sql server DBA

1175

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1002

---

who owns the operating system files created by the utl_file package?

1074

---

how can you implement fine-grained auditing?

1136

---

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

2251

---

Explain materialized views and how they are used.

2443

---

What happens on checkpoint? : sql server DBA

1095

---

how can you find out if a table can be redefined?

1014

---

what is the diffrence between core dba and apps dba?

2570

---

Explain about your sql server dba experience? : sql server DBA

1082

---