Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3801 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 are the objectives of rdbms?
How do you set up a database?
What are the main characteristics of database approach?
What are the types of tables in database?
Where is database data stored?
What are the differences between drop, truncate and delete commands?
What is openedge abl in terms of taking the perspective of the developer?
What do you understand by sub-queries in sql?
What is a concurrency problem in dbms?
What is a relation in dbms?
What do you mean by cardinality and its types?
What is the largest component of a database?
what are the differences between an exclusive lock and a shared lock?
What is the normal procedure followed by a java client to access the db?
What is Data Redundancy and Consistency ?
