Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3701 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 tabular form?
How to implement a database management system?
Explain about the case statement present in stored procedure?
What is rdbms with diagram?
What is entity and its types?
What is a database in layman terms?
What are the differences between hash join, merge join and nested loops?
What do you mean by query evaluation engine?
Enlist the various transaction phases.
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
What is the importance of database in an organization?
What is buffer manager?
Define database lock and its types.
Explain the term entity in dbms?
dear sir please provide what question will be asked in bank it officer interview
