How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3349 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 |
What is a data type in a database?
Explain the key constraints and constraints on Null Values with examples?
How the size of the table space can be increased?
What is third normal form?
What is data model example?
Define join types.
What is the normal procedure followed by a java client to access the db?
What is table normalization?
What do you mean by durability in dbms?
Explain what are called fat clients and fat servers?
What are collection pools? What are the advantages?
List few ways to code transactions in an efficient manner?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
