Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3806 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
Enlist some commands of ddl?
What is a php database?
How to extract metadata for the entire database?
How does a database store data?
How do you start a database?
What are the basic components of notification services?
What is rdbms with example?
Which is the most used database?
What is Normalization and its different forms?
Can videos be stored in a database?
For each user who needs access, the DBA creates an account in which database?
What is concurrency control?
How to schedule ssas database backup
What do you understand by join?
What is 3nf in dbms?
