How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3174 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
What is db flush?
What is the advantage of database management system?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
How does index hunting help in improving query performance?
What is a database in a website?
What is a candidate key in a database?
What is meant by database system?
What's the difference between 'union' and 'union all' ?
What do you know about DBMS?
What are the database skills?
Is excel a database?
What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?
How do you create a database?
How to retrive a single data from a database
What do you understand by unique key?
