How can we tune if buffer busy wait issue comes in oracle?

Question Posted / uindrajit

1 Answers
3923 Views
IBM, I also Faced
E-Mail Answers

How can we tune if buffer busy wait issue comes in oracle?..

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

More Database Management Interview Questions

What is the use of FULL option in EXP command ?

1 Answers

Explain top-n analysis in DBMS.

1 Answers ITC Indian Tobacco Company,

Tell us about some Dot operator queries?

1 Answers Atos Origin,

Are Constraints exported through Export command?