How can we tune if buffer busy wait issue comes in oracle?
Answer / 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 |
What is the difference between indexes,views,synonyms?
What is the use of TABLES option in EXP command ?
How can you CALL Reports from Forms4.0 ?
What are the functions of rdbms?
How to load a file into database column?
What are the two types of database?
Who is the founder of database?
How many types of database languages are?
Why normalisation is required?
dear sir please provide what question will be asked in CWE in bank it officer
what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms).
what are the differences you find when working with oracle 91 and sql server 2005?