Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3700 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 |
Why rdbms is called relational?
What do you mean by deadlock dbms?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
What is an advantage of a database?
How do you set a primary key?
What are the three main types of models?
How to detect applications and users that hold transactions open too long?
How easy is netlib to use?
What are the characteristics of database?
What are procedures in dbms?
What is data example?
What are the advantages of 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)
