Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3880 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 are the components of rdbms?
Explain what are triggers and rules?
What is the relationship?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
How to Handle Missing Data in a Database?
Explain the term entity set in dbms?
Define database system.
What is the main purpose of database?
Define weak entity set.
Which free database is best?
What is the use of FULL option in EXP command ?
what is Data Definiton Language ?
-
Oracle (3253) - 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)
