How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3369 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kd
buffer busy wait indicates that there are some buffers in
the buffer cache that multiple processes are attempting to
access concurrently.
General goal is to reduce total I/IO on the system by:
DBWR contention tuning.
Implementing ASSM.
Adding freelists to table and index.
Tuning sql to access rows with fewer blocks reads by adding
indexes.
select * from v$waitstat
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does a database partition work?
How many records can a database hold?
How to stop superserver service on linux using only firebird tools?
Explain relational algebra?
What are the features of dbms?
What do you understand by cursor?
What do you understand by aggregation and atomicity?
What is file manager?
How to detect applications and users that hold transactions open too long?
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com
What are the different levels of abstraction in the dbms?
What are the characteristics of dbms?
What is a checkpoint and When does it occur in database?
Define the relationship between ‘view’ and ‘data independence’.
Define database model.
