Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3879 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
dear sir please provide what question will be asked in CWE in bank it officer
What are the advantages of database software?
What is a 3nf table?
What is environment of openedge?
What is database partition key?
Why indexing is used in database?
What is the purpose of normalization in dbms?
How to migrate paradox, dbase or foxpro database to firebird?
What is the most used database?
Explain environment of openedge?
How do you create a report in a database?
In DBMS, what are the two integrity rules used?
hello to all i want code for like this site "Submit Question" page.please give answers thanks.
What is the best free database software?
What are the disadvantages of a query?
