Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3791 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
Explain environment of openedge?
Explain about the case statement present in stored procedure?
What is rdbms and also explain its components?
What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?
Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.
Can we assign Explicitly transaction to a rollback segment
Explain what is a deadlock and mention how it can be resolved?
What is 1nf?
What is Two-Phase Commit ?
Enlist the various transaction phases.
State three differences between Dbms and Rdbms?
What are the components of a database management system?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
