How can we tune if buffer busy wait issue comes in oracle?
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
explain the term ‘attribute’?
Which database is used by google?
Describe the difference between homogeneous and heterogeneous distributed database.
What is an entity-relationship model?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
What is the difference between star flake and snow flake schema?
Which free database is best?
What's the difference between delete and truncate ?
What is meant by database system?
Explain what is a deadlock and mention how it can be resolved?
Tell us about some Dot operator queries?
What is drivermanager getconnection?
Mention the differences between the clustered and non-clustered index
does pl/sql support “overloading”? Explain
How do I create a database in access 2010?