How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3172 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 form used for in a database?
What is 1nf 2nf 3nf in dbms?
What are the different types of DBMS architecture?
In which format image is stored in database?
how to restore particular schema from rman full backup?
Is it possible to open a cursor which is in a Package in another database?
What do you understand by aggregation and atomicity?
What do you mean by Correlated subquery in database?
Can we linked SharePoint to a SQL databasebe?
0 Answers Sans Pareil IT Services,
What is an entity-relationship model?
how can we restore RMAN backup from SUN O/S to AIX 5.3? is it possible or not?
What is the database approach?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
