Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3788 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 to extract metadata for the entire database?
What is an example of a database?
Explain the terms database and dbms. Also, mention the different types of dbms.
Mention the differences between union and union all
What is in a database?
What are records and fields in a database?
What do you understand by b-trees?
What is foreign key in dbms?
What is the most popular database?
What are the uses of database management system?
What is system r? How many of its two major subsystems?
Which database is used by google?
what is storage manager?
What is the Structural difference between bitmap and b-tree index ?
Explain openquery function and openrowset function?
