Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune if buffer busy wait issue comes in oracle?
- 1 Answers
- 3722 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 do you mean by deadlock dbms?
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
What is an advantage of a database?
What is advantages of progress actional?
Can you explain fourth normal form and fifth normal form ?
What are stored-procedures? And what are the advantages of using them.
What is the concept of sub-query in terms of sql?
What are the uses of database management system?
What is field in database give an example?
What type of file is used for porting Forms 4.5 applications to various platforms?
what are database files, control files and log files. How many of these files should a database have at least? Why?
select Nth highest salary by using rownum
4 Answers Ford, TCS, Tech Mahindra,
-
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)
