How can we tune if buffer busy wait issue comes in oracle?
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 the use case where we can use stretch database?
What does rdbms stand for?
What are the various Database states.
What is a php database?
i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.
What do you mean by cardinality and its types?
how to solve cardinality in dbms...many to many ralationships
What is flag in database?
What is pcbs (program communication blocks)?
Explain ddl interpreter?
What is database definition (dbd)?
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
What are the elements of a database?
Describe the difference between embedded and dynamic sql.
hello to all i want code for like this site "Submit Question" page.please give answers thanks.